| Field |
Description |
Type |
Size |
Related |
Default Value |
Constraints |
| BatchNum |
Journal Voucher No. |
Int |
11 |
OBTD |
|
|
|
| TransId |
Transaction Number |
Int |
11 |
- |
|
|
|
| BtfStatus |
Status |
VarChar |
1 |
- |
O |
O |
Open |
| |
|
|
|
|
|
C |
Closed |
| TransType |
Origin |
nVarChar |
20 |
- |
-1 |
16 |
Returns |
| |
|
|
|
|
|
203 |
A/R Down Payment |
| |
|
|
|
|
|
15 |
Delivery |
| |
|
|
|
|
|
13 |
A/R Invoice |
| |
|
|
|
|
|
165 |
A/R Correction Invoice |
| |
|
|
|
|
|
166 |
A/R Correction Invoice Reversal |
| |
|
|
|
|
|
14 |
A/R Credit Memo |
| |
|
|
|
|
|
132 |
Correction Invoice |
| |
|
|
|
|
|
20 |
Goods Receipt PO |
| |
|
|
|
|
|
21 |
Goods Return |
| |
|
|
|
|
|
204 |
A/P Down Payment |
| |
|
|
|
|
|
18 |
A/P Invoice |
| |
|
|
|
|
|
163 |
A/P Correction Invoice |
| |
|
|
|
|
|
164 |
A/P Correction Invoice Reversal |
| |
|
|
|
|
|
19 |
A/P Credit Memo |
| |
|
|
|
|
|
281 |
A/P Tax Invoice |
| |
|
|
|
|
|
69 |
Landed Costs |
| |
|
|
|
|
|
140000009 |
Outgoing Excise Invoice |
| |
|
|
|
|
|
140000010 |
Incoming Excise Invoice |
| |
|
|
|
|
|
254000065 |
Self Invoice |
| |
|
|
|
|
|
254000066 |
Self Credit Memo |
| |
|
|
|
|
|
10000079 |
TDS Adjustment |
| |
|
|
|
|
|
24 |
Incoming Payment |
| |
|
|
|
|
|
25 |
Deposit |
| |
|
|
|
|
|
46 |
Outgoing Payment |
| |
|
|
|
|
|
57 |
Checks for Payment |
| |
|
|
|
|
|
76 |
Postdated Deposit |
| |
|
|
|
|
|
182 |
BoE Transaction |
| |
|
|
|
|
|
-2 |
Opening Balance |
| |
|
|
|
|
|
-3 |
Closing Balance |
| |
|
|
|
|
|
321 |
Internal Reconciliation |
| |
|
|
|
|
|
10000046 |
Data Archive |
| |
|
|
|
|
|
30 |
Journal Entry |
| |
|
|
|
|
|
58 |
Inventory List |
| |
|
|
|
|
|
59 |
Goods Receipt |
| |
|
|
|
|
|
60 |
Goods Issue |
| |
|
|
|
|
|
67 |
Inventory Transfers |
| |
|
|
|
|
|
68 |
Work Instructions |
| |
|
|
|
|
|
162 |
Inventory Valuation |
| |
|
|
|
|
|
202 |
Production Order |
| |
|
|
|
|
|
1470000049 |
Fixed Asset Capitalization |
| |
|
|
|
|
|
1470000060 |
Fixed Asset Capitalization Credit Memo |
| |
|
|
|
|
|
1470000094 |
Fixed Asset Retirement |
| |
|
|
|
|
|
1470000075 |
Fixed Asset Manual Depreciation |
| |
|
|
|
|
|
1470000090 |
Fixed Asset Transfer |
| |
|
|
|
|
|
1470000085 |
Fixed Asset Revaluation |
| |
|
|
|
|
|
1470000071 |
Depreciation Run |
| |
|
|
|
|
|
-1 |
All Transactions |
| |
|
|
|
|
|
310000001 |
Inventory Opening Balance |
| |
|
|
|
|
|
10000071 |
Inventory Posting |
| |
|
|
|
|
|
254000061 |
Input Service Distribution Invoice |
| |
|
|
|
|
|
254000062 |
Input Service Distribution Recipient Invoice |
| |
|
|
|
|
|
254000063 |
Input Service Distribution Credit Memo |
| |
|
|
|
|
|
254000064 |
Input Service Distribution Recipient Credit Memo |
| |
|
|
|
|
|
-4 |
Adj. for Manual Ext. Reconciliation |
| BaseRef |
Origin No. |
nVarChar |
11 |
- |
|
|
|
| RefDate |
Posting Date |
Date |
8 |
- |
|
|
|
| Memo |
Remarks |
nVarChar |
254 |
- |
|
|
|
| Ref1 |
Reference 1 |
nVarChar |
200 |
- |
|
|
|
| Ref2 |
Reference 2 |
nVarChar |
200 |
- |
|
|
|
| CreatedBy |
Original |
Int |
11 |
- |
|
|
|
| LocTotal |
Total in Local Currency |
Num |
19.6 |
- |
|
|
|
| FcTotal |
Total in Foreign Currency |
Num |
19.6 |
- |
|
|
|
| SysTotal |
Total in System Currency |
Num |
19.6 |
- |
|
|
|
| TransCode |
Transaction Code |
nVarChar |
4 |
OTRC |
|
|
|
| OrignCurr |
Revaluation Currency |
nVarChar |
3 |
OCRN |
|
|
|
| TransRate |
Revaluation Rate |
Num |
19.6 |
- |
|
|
|
| BtfLine |
Row in Voucher |
Int |
11 |
- |
|
|
|
| TransCurr |
Transaction Currency |
nVarChar |
3 |
- |
|
|
|
| Project |
Project Code |
nVarChar |
20 |
OPRJ |
|
|
|
| DueDate |
Due Date |
Date |
8 |
- |
|
|
|
| TaxDate |
Document Date |
Date |
8 |
- |
|
|
|
| PCAddition |
PC Addition |
VarChar |
1 |
- |
N |
Y |
Yes |
| |
|
|
|
|
|
N |
No |
| FinncPriod |
Posting Period |
Int |
11 |
OFPR |
|
|
|
| DataSource |
Data Source |
VarChar |
1 |
- |
N |
N |
Unknown |
| |
|
|
|
|
|
I |
Interface |
| |
|
|
|
|
|
U |
Update |
| |
|
|
|
|
|
M |
Import |
| |
|
|
|
|
|
O |
DI API |
| |
|
|
|
|
|
S |
Service Layer |
| |
|
|
|
|
|
W |
Web Client |
| |
|
|
|
|
|
A |
Doc. Generation Wizard |
| |
|
|
|
|
|
D |
Restore Wizard |
| |
|
|
|
|
|
P |
Partner Implementation |
| |
|
|
|
|
|
T |
Year Transfer |
| UpdateDate |
Date of Update |
Date |
8 |
- |
|
|
|
| CreateDate |
Recording Date |
Date |
8 |
- |
|
|
|
| UserSign |
User Signature |
Int |
6 |
OUSR |
|
|
|
| UserSign2 |
Updating User |
Int |
6 |
OUSR |
|
|
|
| RefndRprt |
Repayment Report |
VarChar |
1 |
- |
N |
Y |
Yes |
| |
|
|
|
|
|
N |
No |
| LogInstanc |
Log Instance |
Int |
11 |
- |
0 |
|
|
| ObjType |
Object Type |
nVarChar |
20 |
ADP1 |
30 |
|
|
| Indicator |
Indicator Code |
nVarChar |
2 |
OIDC |
|
|
|
| AdjTran |
Adjusting Transaction |
VarChar |
1 |
- |
N |
Y |
Yes |
| |
|
|
|
|
|
N |
No |
| RevSource |
Revaluation Source |
VarChar |
1 |
- |
N |
F |
FC |
| |
|
|
|
|
|
S |
System |
| |
|
|
|
|
|
N |
No |
| StornoDate |
Reversal Date |
Date |
8 |
- |
|
|
|
| StornoToTr |
Reverse Transaction |
Int |
11 |
- |
|
|
|
| AutoStorno |
Use Auto-Reverse |
VarChar |
1 |
- |
N |
Y |
Yes |
| |
|
|
|
|
|
N |
No |
| Corisptivi |
Transaction Values |
VarChar |
1 |
- |
N |
Y |
Yes |
| |
|
|
|
|
|
N |
No |
| VatDate |
VAT Date |
Date |
8 |
- |
|
|
|
| StampTax |
Stamp Tax |
VarChar |
1 |
- |
N |
Y |
Yes |
| |
|
|
|
|
|
N |
No |
| Series |
Series |
Int |
11 |
- |
0 |
|
|
| Number |
Number |
Int |
11 |
- |
|
|
|
| AutoVAT |
Automatic Tax |
VarChar |
1 |
- |
N |
Y |
Yes |
| |
|
|
|
|
|
N |
No |
| DocSeries |
Document Series |
Int |
11 |
- |
|
|
|
| FolioPref |
Folio Prefix String |
nVarChar |
4 |
- |
|
|
|
| FolioNum |
Folio Number |
Int |
11 |
- |
|
|
|
| CreateTime |
Generation Time |
Int |
6 |
- |
|
|
|
| BlockDunn |
Block Dunning Letter |
VarChar |
1 |
- |
N |
N |
No |
| |
|
|
|
|
|
Y |
Yes |
| ReportEU |
Include in EU Report |
VarChar |
1 |
- |
N |
Y |
Yes |
| |
|
|
|
|
|
N |
No |
| Report347 |
Include in 347 Report |
VarChar |
1 |
- |
N |
Y |
Yes |
| |
|
|
|
|
|
N |
No |
| Printed |
Printed |
VarChar |
1 |
- |
N |
Y |
Yes |
| |
|
|
|
|
|
N |
No |
| DocType |
Document Type |
nVarChar |
60 |
OJET |
|
|
|
| AttNum |
Number of Attachments |
Int |
11 |
- |
0 |
|
|
| GenRegNo |
Generate Reg. No. or Not |
VarChar |
1 |
- |
N |
Y |
Yes |
| |
|
|
|
|
|
N |
No |
| RG23APart2 |
RG23A Part2 No |
Int |
11 |
- |
|
|
|
| RG23CPart2 |
RG23C Part2 No |
Int |
11 |
- |
|
|
|
| MatType |
Material Type |
Int |
11 |
- |
|
|
|
| Creator |
Creator Name |
nVarChar |
155 |
- |
|
|
|
| Approver |
Approver Name |
nVarChar |
155 |
- |
|
|
|
| Location |
Loc. |
Int |
11 |
OLCT |
|
|
|
| SeqCode |
Sequence Code |
Int |
6 |
- |
|
|
|
| Serial |
Serial Number |
Int |
11 |
- |
|
|
|
| SeriesStr |
Series String |
nVarChar |
3 |
- |
|
|
|
| SubStr |
Subseries String |
nVarChar |
3 |
- |
|
|
|
| AutoWT |
Automatic WTax |
VarChar |
1 |
- |
N |
Y |
Yes |
| |
|
|
|
|
|
N |
No |
| WTSum |
WTax Amount |
Num |
19.6 |
- |
|
|
|
| WTSumSC |
WTax Amount (SC) |
Num |
19.6 |
- |
|
|
|
| WTSumFC |
WTax Amount (FC) |
Num |
19.6 |
- |
|
|
|
| WTApplied |
Applied WTax |
Num |
19.6 |
- |
|
|
|
| WTAppliedS |
Applied WTax (SC) |
Num |
19.6 |
- |
|
|
|
| WTAppliedF |
Applied WTax (FC) |
Num |
19.6 |
- |
|
|
|
| BaseAmnt |
Base Amount |
Num |
19.6 |
- |
|
|
|
| BaseAmntSC |
Base Amount (SC) |
Num |
19.6 |
- |
|
|
|
| BaseAmntFC |
Base Amount (FC) |
Num |
19.6 |
- |
|
|
|
| BaseVtAt |
WTax Base VAT Amount |
Num |
19.6 |
- |
|
|
|
| BaseVtAtSC |
WTax Base VAT Amount (SC) |
Num |
19.6 |
- |
|
|
|
| BaseVtAtFC |
WTax Base VAT Amount (FC) |
Num |
19.6 |
- |
|
|
|
| VersionNum |
Version Number |
nVarChar |
13 |
- |
|
|
|
| BaseTrans |
Base Transaction Number |
Int |
11 |
- |
|
|
|
| ResidenNum |
Residence Number |
VarChar |
1 |
- |
1 |
1 |
Spanish Fiscal ID |
| |
|
|
|
|
|
2 |
VAT Registration Number |
| |
|
|
|
|
|
3 |
Passport |
| |
|
|
|
|
|
4 |
Fiscal ID Issued by the Country/Region of Residence |
| |
|
|
|
|
|
5 |
Certificate of Fiscal Residence |
| |
|
|
|
|
|
6 |
Other Document |
| OperatCode |
Operation Code |
VarChar |
1 |
- |
|
|
|
| |
|
|
|
|
|
A |
Summary Invoices Entry |
| |
|
|
|
|
|
B |
Summary Receipts Entry |
| |
|
|
|
|
|
C |
Invoice with Several VAT Rates |
| |
|
|
|
|
|
D |
Correction Invoice |
| |
|
|
|
|
|
E |
Due VAT Pending Invoice Issuance |
| |
|
|
|
|
|
F |
Expenses Incurred by Travel Agent for Customers |
| |
|
|
|
|
|
G |
Special Regulation for VAT Group |
| |
|
|
|
|
|
H |
Special Regulation for Gold Investment |
| |
|
|
|
|
|
I |
Reverse Charge Procedure |
| |
|
|
|
|
|
J |
Unsummarized Receipts |
| |
|
|
|
|
|
K |
Identification of Error Transactions |
| |
|
|
|
|
|
X |
Transactions with Entrepreneurs Issuing Receipts for Agricultural Compensation |
| |
|
|
|
|
|
N |
Service Invoicing by Travel Agencies on Behalf of Third Parties |
| |
|
|
|
|
|
R |
Business Office Rental |
| |
|
|
|
|
|
S |
Subsidies |
| |
|
|
|
|
|
T |
Incoming Payments for Industrial and Intellectual Property Rights |
| |
|
|
|
|
|
U |
Insurance Transactions |
| |
|
|
|
|
|
V |
Purchases from Travel Agencies |
| |
|
|
|
|
|
W |
Transactions Subject to Production, Service, and Import Taxes in Ceuta and Melilla |
| |
|
|
|
|
|
Z |
Deferred Tax - Special Regime |
| |
|
|
|
|
|
1 |
Deferred Tax - Summary Invoices Entry |
| |
|
|
|
|
|
2 |
Deferred Tax - Invoices with Several Entries (More Than One Tax Group) |
| |
|
|
|
|
|
3 |
Deferred Tax - Correction Invoice |
| |
|
|
|
|
|
4 |
Deferred Tax - Acquisitions Made by Travel Agencies in the Travelers Own Interest (Special Regime for Travel Agencies) |
| |
|
|
|
|
|
5 |
Deferred Tax - Simplified Invoices |
| |
|
|
|
|
|
6 |
Deferred Tax - Correction of Errata Entries |
| |
|
|
|
|
|
7 |
Deferred Tax - Travel Agency Services on Behalf of Third Parties |
| |
|
|
|
|
|
8 |
Deferred Tax - Rental of Business Premises |
| Ref3 |
Reference 3 |
nVarChar |
200 |
- |
|
|
|
| SSIExmpt |
SSI Exemption |
VarChar |
1 |
- |
|
Y |
Yes |
| |
|
|
|
|
|
N |
No |
| SignMsg |
Signature Input Message |
Text |
16 |
- |
|
|
|
| SignDigest |
Signature Digest |
Text |
16 |
- |
|
|
|
| CertifNum |
Certification Number |
nVarChar |
50 |
- |
|
|
|
| KeyVersion |
Private Key Version |
Int |
11 |
- |
|
|
|
| CUP |
Unique Code of Project |
Int |
11 |
OCUP |
|
|
|
| CIG |
Contract Code Identification |
Int |
11 |
OCIG |
|
|
|
| SupplCode |
Supplementary Code |
nVarChar |
254 |
- |
|
|
|
| SPSrcType |
Service Posting Source Type |
Int |
11 |
- |
|
|
|
| SPSrcID |
Service Posting Source ID |
Int |
11 |
- |
|
|
|
| SPSrcDLN |
Service Post. Source Delivery |
Int |
11 |
- |
|
|
|
| DeferedTax |
Deferred Tax |
VarChar |
1 |
- |
N |
Y |
Yes |
| |
|
|
|
|
|
N |
No |
| AgrNo |
Blanket Agreement Number |
Int |
11 |
OOAT |
|
|
|
| SeqNum |
Sequence Number |
Int |
11 |
- |
|
|
|
| ECDPosTyp |
ECD Posting Type |
VarChar |
1 |
- |
N |
N |
Normal |
| |
|
|
|
|
|
E |
Statement |
| RptPeriod |
Reporting Period |
nVarChar |
5 |
- |
|
|
|
| RptMonth |
Reporting Month |
Date |
8 |
- |
|
|
|
| ExTransId |
Exposed Transaction ID |
Int |
11 |
- |
|
|
|
| PrlLinked |
Is JE linked by MX Payroll |
VarChar |
1 |
- |
N |
Y |
Yes |
| |
|
|
|
|
|
N |
No |
| PTICode |
POI Code |
nVarChar |
5 |
OPTI |
|
|
|
| Letter |
Letter |
VarChar |
1 |
- |
|
|
|
| FolNumFrom |
Folio Number From |
Int |
11 |
- |
|
|
|
| FolNumTo |
Folio Number To |
Int |
11 |
- |
|
|
|
| RepSection |
Reporting Section |
nVarChar |
3 |
- |
|
|
|
| ExclTaxRep |
Exclude from Control Statement |
VarChar |
1 |
- |
N |
Y |
Yes |
| |
|
|
|
|
|
N |
No |
| IsCoEntry |
Cost Center Transfer form |
VarChar |
1 |
- |
N |
Y |
Yes |
| |
|
|
|
|
|
N |
No |
| SAPPassprt |
Extended SAP Passport |
Text |
16 |
- |
|
|
|
| AtcEntry |
Attachment Entry |
Int |
11 |
OATC |
|
|
|
| Attachment |
Attachment |
Text |
16 |
- |
|
|
|
| EBookable |
E-Books Enabled |
VarChar |
1 |
- |
N |
N |
No |
| |
|
|
|
|
|
Y |
Yes |
| DataVers |
Data Version |
Int |
11 |
- |
1 |
|
|
| SAFTType |
SAF-T Transaction Type |
VarChar |
1 |
- |
- |
- |
- |
| |
|
|
|
|
|
N |
Normal |
| |
|
|
|
|
|
R |
Adjustments of Tax Period |
| |
|
|
|
|
|
A |
Measurement of Results |
| |
|
|
|
|
|
J |
Adjustment |
| |
|
|
|
|
|
I |
Do Not Export |
| AllocNum |
Allocation Number for IL |
nVarChar |
50 |
- |
|
|
|
| SAFTTypeEx |
SAF-T Transaction Type |
nVarChar |
10 |
OSTE |
- |
|
|