| Field |
Description |
Type |
Size |
Related |
Default Value |
Constraints |
| DocEntry |
Internal Number |
Int |
11 |
- |
|
|
|
| DocNum |
Document Number |
Int |
11 |
- |
|
|
|
| DocType |
Document Type |
VarChar |
1 |
- |
C |
C |
Customer |
| |
|
|
|
|
|
A |
Account |
| |
|
|
|
|
|
S |
Vendor |
| |
|
|
|
|
|
P |
P.L.A |
| |
|
|
|
|
|
T |
Tax |
| |
|
|
|
|
|
D |
TDS |
| Canceled |
Canceled |
VarChar |
1 |
- |
N |
Y |
Yes |
| |
|
|
|
|
|
N |
No |
| Handwrtten |
Manual Numbering |
VarChar |
1 |
- |
N |
Y |
Yes |
| |
|
|
|
|
|
N |
No |
| Printed |
Printed |
VarChar |
1 |
- |
N |
Y |
Copy |
| |
|
|
|
|
|
N |
Original |
| DocDate |
Posting Date |
Date |
8 |
- |
|
|
|
| DocDueDate |
Due Date |
Date |
8 |
- |
|
|
|
| CardCode |
Customer/Vendor Code |
nVarChar |
15 |
OCRD |
|
|
|
| CardName |
Customer/Vendor Name |
nVarChar |
200 |
- |
|
|
|
| Address |
Address |
nVarChar |
254 |
- |
|
|
|
| DdctPrcnt |
Deduction Percent |
Num |
19.6 |
- |
|
|
|
| DdctSum |
Total Deductions |
Num |
19.6 |
- |
|
|
|
| DdctSumFC |
Total Deductions (FC) |
Num |
19.6 |
- |
|
|
|
| CashAcct |
Cash Account |
nVarChar |
15 |
OACT |
|
|
|
| CashSum |
Cash Amount |
Num |
19.6 |
- |
|
|
|
| CashSumFC |
Cash Amount (FC) |
Num |
19.6 |
- |
|
|
|
| CreditSum |
Credit Amount |
Num |
19.6 |
- |
|
|
|
| CredSumFC |
Credit Amount (FC) |
Num |
19.6 |
- |
|
|
|
| CheckAcct |
Current Account |
nVarChar |
15 |
OACT |
|
|
|
| CheckSum |
Check Amount |
Num |
19.6 |
- |
|
|
|
| CheckSumFC |
Check Amount (FC) |
Num |
19.6 |
- |
|
|
|
| TrsfrAcct |
Transfer Account |
nVarChar |
15 |
OACT |
|
|
|
| TrsfrSum |
Transfer Amount |
Num |
19.6 |
- |
|
|
|
| TrsfrSumFC |
Transfer Amount (FC) |
Num |
19.6 |
- |
|
|
|
| TrsfrDate |
Transfer Date |
Date |
8 |
- |
|
|
|
| TrsfrRef |
Intended Purpose |
nVarChar |
27 |
- |
|
|
|
| PayNoDoc |
Non-Calculated Payment |
VarChar |
1 |
- |
N |
Y |
Yes |
| |
|
|
|
|
|
N |
No |
| NoDocSum |
Non-Calculated Amount |
Num |
19.6 |
- |
|
|
|
| NoDocSumFC |
Non-Calculated Amount (FC) |
Num |
19.6 |
- |
|
|
|
| DocCurr |
Document Currency |
nVarChar |
3 |
OCRN |
|
|
|
| DiffCurr |
Enter in local currency |
VarChar |
1 |
- |
N |
N |
No |
| |
|
|
|
|
|
Y |
Yes |
| DocRate |
Document Rate |
Num |
19.6 |
- |
|
|
|
| SysRate |
System Price |
Num |
19.6 |
- |
|
|
|
| DocTotal |
Document Total |
Num |
19.6 |
- |
|
|
|
| DocTotalFC |
Document Total (FC) |
Num |
19.6 |
- |
|
|
|
| Ref1 |
Reference 1 |
nVarChar |
11 |
- |
|
|
|
| Ref2 |
Reference 2 |
nVarChar |
50 |
- |
|
|
|
| CounterRef |
Counter Reference |
nVarChar |
50 |
- |
|
|
|
| Comments |
Remarks |
nVarChar |
254 |
- |
|
|
|
| JrnlMemo |
Journal Remarks |
nVarChar |
254 |
- |
|
|
|
| TransId |
Transaction Number |
Int |
11 |
OJDT |
|
|
|
| DocTime |
Generation Time |
Int |
6 |
- |
|
|
|
| ShowAtCard |
Display Customer Ref. No. |
VarChar |
1 |
- |
N |
Y |
Yes |
| |
|
|
|
|
|
N |
No |
| SpiltTrans |
Split Transaction Journal |
VarChar |
1 |
- |
N |
Y |
Yes |
| |
|
|
|
|
|
N |
No |
| CreateTran |
Create Journal Entry |
VarChar |
1 |
- |
Y |
Y |
Yes |
| |
|
|
|
|
|
N |
No |
| Flags |
Flags |
Int |
11 |
- |
0 |
|
|
| CntctCode |
Contact Person |
Int |
11 |
OCPR |
|
|
|
| DdctSumSy |
System Deduction Amount |
Num |
19.6 |
- |
|
|
|
| CashSumSy |
Cash Amount (SC) |
Num |
19.6 |
- |
|
|
|
| CredSumSy |
System Credit Amount |
Num |
19.6 |
- |
|
|
|
| CheckSumSy |
Check Amount (SC) |
Num |
19.6 |
- |
|
|
|
| TrsfrSumSy |
Transfer Amount (SC) |
Num |
19.6 |
- |
|
|
|
| NoDocSumSy |
Non-Invoiced System Amount |
Num |
19.6 |
- |
|
|
|
| DocTotalSy |
Document Total (SC) |
Num |
19.6 |
- |
|
|
|
| ObjType |
Object Type |
nVarChar |
20 |
ADP1 |
24 |
24 |
Incoming Payment |
| StornoRate |
Cancellation Rate |
Num |
19.6 |
- |
|
|
|
| UpdateDate |
Date of Update |
Date |
8 |
- |
|
|
|
| CreateDate |
Creation Date |
Date |
8 |
- |
|
|
|
| ApplyVAT |
Tax Definition |
VarChar |
1 |
- |
N |
Y |
Yes |
| |
|
|
|
|
|
N |
No |
| TaxDate |
Document Date |
Date |
8 |
- |
|
|
|
| Series |
Series |
Int |
11 |
NNM1 |
|
|
|
| confirmed |
Approved |
VarChar |
1 |
- |
N |
Y |
Yes |
| |
|
|
|
|
|
N |
No |
| ShowJDT |
Display Journal Entries |
VarChar |
1 |
- |
N |
Y |
Yes |
| |
|
|
|
|
|
N |
No |
| BankCode |
Bank Code for Bank Transfer |
nVarChar |
30 |
- |
|
|
|
| BankAcct |
Account for Bank Transfer |
nVarChar |
50 |
- |
|
|
|
| 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 |
| |
|
|
|
|
|
B |
BSP |
| UserSign |
User Signature |
Int |
6 |
OUSR |
|
|
|
| LogInstanc |
Log Instance |
Int |
11 |
- |
0 |
|
|
| VatGroup |
Tax Group |
nVarChar |
8 |
OVTG |
|
|
|
| VatSum |
Tax Amount |
Num |
19.6 |
- |
|
|
|
| VatSumFC |
Tax Amount (FC) |
Num |
19.6 |
- |
|
|
|
| VatSumSy |
Tax Amount (SC) |
Num |
19.6 |
- |
|
|
|
| FinncPriod |
Posting Period |
Int |
11 |
OFPR |
|
|
|
| VatPrcnt |
Tax % |
Num |
19.6 |
- |
|
|
|
| Dcount |
Discount % |
Num |
19.6 |
- |
|
|
|
| DcntSum |
Discount Amount |
Num |
19.6 |
- |
|
|
|
| DcntSumFC |
Discount Amount (FC) |
Num |
19.6 |
- |
|
|
|
| DcntSumSy |
Discount Amount (SC) |
Num |
19.6 |
- |
|
|
|
| SpltCredLn |
Split Vendor Credit Row |
VarChar |
1 |
- |
N |
Y |
Yes |
| |
|
|
|
|
|
N |
No |
| PrjCode |
Project |
nVarChar |
20 |
OPRJ |
|
|
|
| PaymentRef |
Payment Reference No. |
nVarChar |
27 |
- |
|
|
|
| Submitted |
Submitted |
VarChar |
1 |
- |
N |
Y |
Yes |
| |
|
|
|
|
|
N |
No |
| Status |
Created by Payment Run |
VarChar |
1 |
- |
N |
Y |
Yes |
| |
|
|
|
|
|
N |
No |
| |
|
|
|
|
|
C |
BoE Canceled |
| PayMth |
Payment Method |
nVarChar |
15 |
OPYM |
|
|
|
| BankCountr |
Bank Country/Region |
nVarChar |
3 |
OCRY |
|
|
|
| FreightSum |
Freight Sum |
Num |
19.6 |
- |
|
|
|
| FreigtFC |
Freight Sum (FC) |
Num |
19.6 |
- |
|
|
|
| FreigtSC |
Freight Sum (SC) |
Num |
19.6 |
- |
|
|
|
| BoeAcc |
Boe Account |
nVarChar |
15 |
OACT |
|
|
|
| BoeNum |
Bill of Exchange No. |
Int |
11 |
- |
|
|
|
| BoeSum |
Bill of Exchange Amount |
Num |
19.6 |
- |
|
|
|
| BoeSumFc |
Bill of Exchange Amount (FC) |
Num |
19.6 |
- |
|
|
|
| BoeSumSc |
Bill of Exchange Amount (SC) |
Num |
19.6 |
- |
|
|
|
| BoeAgent |
Bill of Exchange Agent |
nVarChar |
32 |
OAGP |
|
|
|
| BoeStatus |
Bill of Exchange Status |
VarChar |
1 |
- |
|
|
|
| WtCode |
WTax Code |
nVarChar |
4 |
OWHT |
|
|
|
| WtSum |
WTax Amount |
Num |
19.6 |
- |
|
|
|
| WtSumFrgn |
WTax Amount (FC) |
Num |
19.6 |
- |
|
|
|
| WtSumSys |
WTax Amount (SC) |
Num |
19.6 |
- |
|
|
|
| WtAccount |
WTax Account |
nVarChar |
15 |
OACT |
|
|
|
| WtBaseAmnt |
WTax Taxable Amount |
Num |
19.6 |
- |
|
|
|
| Proforma |
Proforma |
VarChar |
1 |
- |
N |
Y |
Yes |
| |
|
|
|
|
|
N |
No |
| BoeAbs |
Boe Key |
Int |
11 |
OBOE |
|
|
|
| BpAct |
BP Account |
nVarChar |
15 |
OACT |
|
|
|
| BcgSum |
Bank Charges Amount |
Num |
19.6 |
- |
|
|
|
| BcgSumFC |
Bank Charges Amount (FC) |
Num |
19.6 |
- |
|
|
|
| BcgSumSy |
Bank Charges Amount (SC) |
Num |
19.6 |
- |
|
|
|
| PIndicator |
Period Indicator |
nVarChar |
10 |
OPID |
' ' |
|
|
| PaPriority |
Payment Priority |
VarChar |
1 |
- |
6 |
1 |
|
| |
|
|
|
|
|
2 |
|
| |
|
|
|
|
|
3 |
|
| |
|
|
|
|
|
4 |
|
| |
|
|
|
|
|
5 |
|
| |
|
|
|
|
|
6 |
|
| PayToCode |
Pay To |
nVarChar |
50 |
- |
|
|
|
| IsPaytoBnk |
Is Pay to Bank |
VarChar |
1 |
- |
N |
N |
No |
| |
|
|
|
|
|
Y |
Yes |
| PBnkCnt |
Pay to Bank Country/Region |
nVarChar |
3 |
OCRY |
|
|
|
| PBnkCode |
Pay to Bank Code |
nVarChar |
30 |
- |
|
|
|
| PBnkAccnt |
Pay to Bank Account No. |
nVarChar |
50 |
- |
|
|
|
| PBnkBranch |
Pay to Bank Branch |
nVarChar |
50 |
- |
|
|
|
| WizDunBlck |
Wizard Dunning Block |
VarChar |
1 |
- |
N |
N |
No |
| |
|
|
|
|
|
Y |
Yes |
| WtBaseSum |
WTax Base Sum |
Num |
19.6 |
- |
|
|
|
| WtBaseSumF |
WTax Base Sum (FC) |
Num |
19.6 |
- |
|
|
|
| WtBaseSumS |
WTax Base Sum (SC) |
Num |
19.6 |
- |
|
|
|
| UndOvDiff |
Under/Overpayment Difference |
Num |
19.6 |
- |
|
|
|
| UndOvDiffS |
Under/Overpayment Diff. (SC) |
Num |
19.6 |
- |
|
|
|
| BankActKey |
Bank Account Internal ID |
Int |
11 |
DSC1 |
|
|
|
| VersionNum |
Version Number |
nVarChar |
13 |
- |
|
|
|
| VatDate |
VAT Date |
Date |
8 |
- |
|
|
|
| TransCode |
Transaction Code |
nVarChar |
4 |
OTRC |
|
|
|
| PaymType |
Payment Type |
VarChar |
1 |
- |
N |
N |
|
| |
|
|
|
|
|
E |
Electronic |
| |
|
|
|
|
|
P |
Mail |
| |
|
|
|
|
|
T |
Telegraph |
| |
|
|
|
|
|
X |
Express |
| TfrRealAmt |
Transfer Real Amount |
Num |
19.6 |
- |
|
|
|
| CancelDate |
Cancelation Date |
Date |
8 |
- |
|
|
|
| OpenBal |
Open Balance Amount |
Num |
19.6 |
- |
|
|
|
| OpenBalFc |
Open Balance Amount (FC) |
Num |
19.6 |
- |
|
|
|
| OpenBalSc |
Open Balance Amount (SC) |
Num |
19.6 |
- |
|
|
|
| BcgTaxSum |
Bank Charge Tax Amount |
Num |
19.6 |
- |
|
|
|
| BcgTaxSumF |
Bank Charge Tax Amount(FC) |
Num |
19.6 |
- |
|
|
|
| BcgTaxSumS |
Bank Charge Tax Amount(SC) |
Num |
19.6 |
- |
|
|
|
| TpwID |
Tax Payment Wizard ID |
Int |
11 |
- |
0 |
|
|
| ChallanNo |
Challan No. |
nVarChar |
32 |
- |
|
|
|
| ChallanBak |
Challan Bank Name |
nVarChar |
60 |
- |
|
|
|
| ChallanDat |
Challan Received Date |
Date |
8 |
- |
|
|
|
| WddStatus |
Authorization Status |
VarChar |
1 |
- |
- |
- |
Without |
| |
|
|
|
|
|
W |
Pending |
| |
|
|
|
|
|
Y |
Approved |
| |
|
|
|
|
|
N |
Rejected |
| |
|
|
|
|
|
P |
Generated |
| |
|
|
|
|
|
A |
Generated by Authorizer |
| |
|
|
|
|
|
C |
Canceled |
| BcgVatGrp |
Bank Charge Tax Group |
nVarChar |
8 |
OVTG |
|
|
|
| BcgVatPcnt |
Bank Charge Tax % |
Num |
19.6 |
- |
|
|
|
| SeqCode |
Sequence Code |
Int |
6 |
- |
|
|
|
| Serial |
Serial Number |
Int |
11 |
- |
|
|
|
| SeriesStr |
Series String |
nVarChar |
3 |
- |
|
|
|
| SubStr |
Subseries String |
nVarChar |
3 |
- |
|
|
|
| BSRCode |
BSR Code |
nVarChar |
25 |
- |
|
|
|
| LocCode |
Location Code |
Int |
11 |
OLCT |
|
|
|
| WTOnhldPst |
WTax On Hold, Posted |
Num |
19.6 |
- |
|
|
|
| UserSign2 |
Updating User |
Int |
6 |
OUSR |
|
|
|
| BuildDesc |
Build Descriptor |
nVarChar |
50 |
- |
|
|
|
| ResidenNum |
Residence Number |
VarChar |
1 |
- |
1 |
1 |
Spanish Fiscal ID |
| |
|
|
|
|
|
2 |
VAT Registration Number |
| |
|
|
|
|
|
3 |
Passport |
| |
|
|
|
|
|
4 |
Fiscal ID Issued by the Residence Country/Region |
| |
|
|
|
|
|
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 |
| |
|
|
|
|
|
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 |
| |
|
|
|
|
|
X |
Transactions with Entrepreneurs Issuing Receipts for Agricultural Compensation |
| UndOvDiffF |
Under/Overpayment Diff. (FC) |
Num |
19.6 |
- |
|
|
|
| MIEntry |
MI Entry Include this Payment |
Int |
11 |
- |
0 |
|
|
| FreeText1 |
Free Text 1 |
nVarChar |
254 |
- |
|
|
|
| FreeText2 |
Free Text 2 |
nVarChar |
254 |
- |
|
|
|
| FreeText3 |
Free Text 3 |
nVarChar |
254 |
- |
|
|
|
| ShowDocNo |
Display Document No. |
VarChar |
1 |
- |
Y |
Y |
Yes |
| |
|
|
|
|
|
N |
No |
| TDSInterst |
TDS Interest |
Num |
19.6 |
- |
0 |
|
|
| TDSCharges |
TDS Other Charges |
Num |
19.6 |
- |
0 |
|
|
| CUP |
Unique Code of Project |
Int |
11 |
OCUP |
|
|
|
| CIG |
Contract Code Identification |
Int |
11 |
OCIG |
|
|
|
| MIType |
MI Type Include this Payment |
nVarChar |
20 |
- |
|
270 |
A/R Monthly Invoice |
| |
|
|
|
|
|
140000014 |
A/P Monthly Invoice |
| SupplCode |
Supplementary Code |
nVarChar |
254 |
- |
|
|
|
| BPLId |
Branch |
Int |
11 |
OBPL |
|
|
|
| BPLName |
Branch Name |
nVarChar |
200 |
- |
|
|
|
| VATRegNum |
VAT Reg. Number |
nVarChar |
32 |
- |
|
|
|
| BPLCentPmt |
Centralized Payment |
VarChar |
1 |
- |
N |
N |
No |
| |
|
|
|
|
|
Y |
Yes |
| DraftKey |
Payment Draft Internal ID |
Int |
11 |
OPDF |
|
|
|
| TDSFee |
TDS Fee |
Num |
19.6 |
- |
|
|
|
| MinHeadCL |
Minor Head of Challan |
Int |
11 |
- |
|
200 |
TDS Payable by Taxpayer |
| |
|
|
|
|
|
400 |
TDS Regular Assessment (Raised by IT Dept) |
| SEPADate |
Requested SEPA Pmt Date |
Date |
8 |
- |
|
|
|
| OwnerCode |
Payment Owner |
Int |
11 |
OHEM |
|
|
|
| AgrNo |
Agreement No. |
Int |
11 |
OOAT |
|
|
|
| CreateTS |
Create Time - Incl. Secs |
Int |
11 |
- |
|
|
|
| UpdateTS |
Update Full Time |
Int |
11 |
- |
|
|
|
| TDSType |
TDS Type |
VarChar |
1 |
- |
|
E |
eTDS |
| |
|
|
|
|
|
D |
GST TDS |
| |
|
|
|
|
|
C |
GST TCS |
| DrNo |
Dr. No. |
nVarChar |
32 |
- |
|
|
|
| PmntWTCert |
Payment by WT Certificate Only |
VarChar |
1 |
- |
N |
Y |
Yes |
| |
|
|
|
|
|
N |
No |
| EnPBnkAcct |
Encryption of Pay to Bank Acct |
Text |
16 |
- |
|
|
|
| EncryptIV |
Encrypt IV |
nVarChar |
100 |
- |
|
|
|
| DPPStatus |
Data Protection Status |
VarChar |
1 |
- |
N |
N |
None |
| |
|
|
|
|
|
D |
Erased |
| PriceMode |
Price Mode |
VarChar |
1 |
- |
|
N |
Net |
| |
|
|
|
|
|
G |
Gross |
| AtcEntry |
Attachment Entry |
Int |
11 |
OATC |
|
|
|
| Attachment |
Attachment |
Text |
16 |
- |
|
|
|
| EnblDpmTax |
Enable Tax Calculation in Down Payment Invoices |
VarChar |
1 |
- |
N |
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 |
- |
|
|
|
| QRCodeSPGn |
QR Code Source Generated from Stored Procedure |
Text |
16 |
- |
|
|
|
| DataVers |
Data Version |
Int |
11 |
- |
1 |
|
|
| EDocExpFrm |
Electronic Doc. Export Format |
Int |
11 |
- |
|
|
|
| ElCoStatus |
Elec. Comm. Status |
nVarChar |
10 |
- |
|
0 |
Approved |
| |
|
|
|
|
|
1 |
Pending Approval |
| |
|
|
|
|
|
2 |
Rejected |
| ElCoMsg |
Elec. Comm. Message |
nVarChar |
254 |
- |
|
|
|
| DigPayment |
Digital Payments |
VarChar |
1 |
- |
N |
Y |
Yes |
| |
|
|
|
|
|
N |
No |