| Field |
Description |
Type |
Size |
Related |
Default Value |
Constraints |
| DocEntry |
Numerator |
Int |
11 |
- |
|
|
|
| DocNum |
Document Number |
Int |
11 |
- |
|
|
|
| DocType |
Document Type |
VarChar |
1 |
- |
I |
I |
Item |
| |
|
|
|
|
|
S |
Service |
| 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 |
| |
|
|
|
|
|
A |
Amended |
| DocStatus |
Document Status |
VarChar |
1 |
- |
O |
O |
Open |
| |
|
|
|
|
|
C |
Closed |
| InvntSttus |
Warehouse Status |
VarChar |
1 |
- |
O |
O |
Open |
| |
|
|
|
|
|
C |
Closed |
| Transfered |
Year Transfer |
VarChar |
1 |
- |
N |
Y |
Yes |
| |
|
|
|
|
|
N |
No |
| ObjType |
Object Type |
nVarChar |
20 |
ADP1 |
204 |
204 |
A/P Down Payment |
| DocDate |
Posting Date |
Date |
8 |
- |
|
|
|
| DocDueDate |
Due Date |
Date |
8 |
- |
|
|
|
| CardCode |
Customer/Vendor Code |
nVarChar |
15 |
OCRD |
|
|
|
| CardName |
Customer/Vendor Name |
nVarChar |
200 |
- |
|
|
|
| Address |
Bill To |
nVarChar |
254 |
- |
|
|
|
| NumAtCard |
Customer/Vendor Ref. No. |
nVarChar |
200 |
- |
|
|
|
| VatPercent |
Tax Rate |
Num |
19.6 |
- |
|
|
|
| VatSum |
Total Tax |
Num |
19.6 |
- |
|
|
|
| VatSumFC |
Tax Amount (FC) |
Num |
19.6 |
- |
|
|
|
| DiscPrcnt |
Discount % for Document |
Num |
19.6 |
- |
|
|
|
| DiscSum |
Total Discount |
Num |
19.6 |
- |
|
|
|
| DiscSumFC |
Total Discount (FC) |
Num |
19.6 |
- |
|
|
|
| DocCur |
Document Currency |
nVarChar |
3 |
OCRN |
|
|
|
| DocRate |
Document Rate |
Num |
19.6 |
- |
|
|
|
| DocTotal |
Document Total |
Num |
19.6 |
- |
|
|
|
| DocTotalFC |
Document Total (FC) |
Num |
19.6 |
- |
|
|
|
| PaidToDate |
Paid to Date |
Num |
19.6 |
- |
|
|
|
| PaidFC |
Paid (FC) |
Num |
19.6 |
- |
|
|
|
| GrosProfit |
Gross Profit |
Num |
19.6 |
- |
|
|
|
| GrosProfFC |
Gross Profit (FC) |
Num |
19.6 |
- |
|
|
|
| Ref1 |
Reference 1 |
nVarChar |
11 |
- |
|
|
|
| Ref2 |
Reference 2 |
nVarChar |
11 |
- |
|
|
|
| Comments |
Remarks |
nVarChar |
254 |
- |
|
|
|
| JrnlMemo |
Journal Remarks |
nVarChar |
254 |
- |
|
|
|
| TransId |
Transaction Number |
Int |
11 |
OJDT |
|
|
|
| ReceiptNum |
Receipt Number |
Int |
11 |
- |
|
|
|
| GroupNum |
Payment Terms Code |
Int |
6 |
OCTG |
|
|
|
| DocTime |
Generation Time |
Int |
6 |
- |
|
|
|
| SlpCode |
Sales Employee |
Int |
11 |
OSLP |
-1 |
|
|
| TrnspCode |
Shipping Type |
Int |
6 |
OSHP |
-1 |
|
|
| PartSupply |
Partial Delivery |
VarChar |
1 |
- |
Y |
Y |
Yes |
| |
|
|
|
|
|
N |
No |
| Confirmed |
Confirmed |
VarChar |
1 |
- |
Y |
Y |
Yes |
| |
|
|
|
|
|
N |
No |
| GrossBase |
Price List for Gross Profit |
Int |
6 |
- |
0 |
|
|
| ImportEnt |
Order Number |
Int |
11 |
- |
|
|
|
| CreateTran |
Create Journal Entry |
VarChar |
1 |
- |
N |
Y |
Yes |
| |
|
|
|
|
|
N |
No |
| SummryType |
Summary Method |
VarChar |
1 |
- |
N |
N |
No Summary |
| |
|
|
|
|
|
I |
By Items |
| |
|
|
|
|
|
D |
By Documents |
| UpdInvnt |
Whse Update |
VarChar |
1 |
- |
N |
N |
No |
| |
|
|
|
|
|
O |
Orders from Vendors |
| |
|
|
|
|
|
C |
Customer Orders |
| |
|
|
|
|
|
G |
Consignment |
| |
|
|
|
|
|
I |
Stock |
| UpdCardBal |
Update Balances |
VarChar |
1 |
- |
N |
N |
No |
| |
|
|
|
|
|
O |
Orders |
| |
|
|
|
|
|
D |
Delivery Notes |
| |
|
|
|
|
|
B |
Bookkeeping |
| Instance |
Instance |
Int |
6 |
- |
0 |
|
|
| Flags |
Flags |
Int |
11 |
- |
0 |
|
|
| InvntDirec |
Warehouse Direction |
VarChar |
1 |
- |
X |
X |
Release |
| |
|
|
|
|
|
E |
Receipt |
| CntctCode |
Contact Person |
Int |
11 |
OCPR |
|
|
|
| ShowSCN |
Display BP Catalog Number |
VarChar |
1 |
- |
N |
Y |
Yes |
| |
|
|
|
|
|
N |
No |
| FatherCard |
BP Consolidation |
nVarChar |
15 |
OCRD |
|
|
|
| SysRate |
System Price |
Num |
19.6 |
- |
|
|
|
| CurSource |
Base Currency |
VarChar |
1 |
- |
C |
L |
Local Currency |
| |
|
|
|
|
|
S |
System Currency |
| |
|
|
|
|
|
C |
BP Currency |
| VatSumSy |
Tax Amount (SC) |
Num |
19.6 |
- |
|
|
|
| DiscSumSy |
Total Discount (SC) |
Num |
19.6 |
- |
|
|
|
| DocTotalSy |
Document Total (SC) |
Num |
19.6 |
- |
|
|
|
| PaidSys |
Paid (SC) |
Num |
19.6 |
- |
|
|
|
| FatherType |
Parent Summary Type |
VarChar |
1 |
- |
P |
P |
Payment Consolidation |
| |
|
|
|
|
|
D |
Delivery Consolidation |
| GrosProfSy |
Gross Profit (SC) |
Num |
19.6 |
- |
|
|
|
| UpdateDate |
Date of Update |
Date |
8 |
- |
|
|
|
| IsICT |
A/R Invoice + Payment |
VarChar |
1 |
- |
N |
Y |
Yes |
| |
|
|
|
|
|
N |
No |
| CreateDate |
Creation Date |
Date |
8 |
- |
|
|
|
| Volume |
Volume |
Num |
19.6 |
- |
|
|
|
| VolUnit |
UoM for Volume |
Int |
6 |
- |
|
|
|
| Weight |
Weight |
Num |
19.6 |
- |
|
|
|
| WeightUnit |
Weight UoM |
Int |
6 |
- |
|
|
|
| Series |
Series |
Int |
11 |
NNM1 |
|
|
|
| TaxDate |
Document Date |
Date |
8 |
- |
|
|
|
| Filler |
Filter |
nVarChar |
8 |
OWHS |
|
|
|
| DataSource |
Data Source |
VarChar |
1 |
- |
N |
N |
Unknown |
| |
|
|
|
|
|
I |
Interface |
| |
|
|
|
|
|
U |
Upgrade |
| |
|
|
|
|
|
M |
Import |
| |
|
|
|
|
|
O |
DI API |
| |
|
|
|
|
|
S |
Service Layer |
| |
|
|
|
|
|
W |
Web Client |
| |
|
|
|
|
|
A |
Auto Summary |
| |
|
|
|
|
|
D |
Restore Wizard |
| |
|
|
|
|
|
P |
Partner Implementation |
| |
|
|
|
|
|
T |
Year Transfer |
| StampNum |
Stamp No. |
nVarChar |
16 |
- |
|
|
|
| isCrin |
Correction Invoice |
VarChar |
1 |
- |
N |
Y |
Yes |
| |
|
|
|
|
|
N |
No |
| FinncPriod |
Posting Period |
Int |
11 |
OFPR |
|
|
|
| UserSign |
User Signature |
Int |
6 |
OUSR |
|
|
|
| selfInv |
Autom. Invoice |
VarChar |
1 |
- |
N |
N |
No |
| |
|
|
|
|
|
Y |
Yes |
| VatPaid |
Tax Paid to Date |
Num |
19.6 |
- |
|
|
|
| VatPaidFC |
Tax Paid (FC) |
Num |
19.6 |
- |
|
|
|
| VatPaidSys |
Tax Paid (SC) |
Num |
19.6 |
- |
|
|
|
| UserSign2 |
Updating User |
Int |
6 |
OUSR |
|
|
|
| WddStatus |
Authorization Status |
VarChar |
1 |
- |
- |
- |
Without |
| |
|
|
|
|
|
W |
Pending |
| |
|
|
|
|
|
Y |
Approved |
| |
|
|
|
|
|
N |
Rejected |
| |
|
|
|
|
|
P |
Generated |
| |
|
|
|
|
|
A |
Generated by Authorizer |
| |
|
|
|
|
|
C |
Canceled |
| draftKey |
Document Draft Internal ID |
Int |
11 |
ODRF |
-1 |
|
|
| TotalExpns |
Total Expenses |
Num |
19.6 |
- |
|
|
|
| TotalExpFC |
Total Expenses (FC) |
Num |
19.6 |
- |
|
|
|
| TotalExpSC |
Total Expenses (SC) |
Num |
19.6 |
- |
|
|
|
| DunnLevel |
Dunning Level |
Int |
11 |
ODUN |
|
|
|
| Address2 |
Ship To |
nVarChar |
254 |
- |
|
|
|
| LogInstanc |
Log Instance |
Int |
11 |
- |
0 |
|
|
| Exported |
Exported |
VarChar |
1 |
- |
N |
Y |
Yes |
| |
|
|
|
|
|
N |
No |
| StationID |
Workstation ID |
Int |
11 |
CSTN |
|
|
|
| Indicator |
Indicator |
nVarChar |
2 |
OIDC |
|
|
|
| NetProc |
Net Procedure |
VarChar |
1 |
- |
N |
Y |
Yes |
| |
|
|
|
|
|
N |
No |
| AqcsTax |
Acquisition Tax |
Num |
19.6 |
- |
|
|
|
| AqcsTaxFC |
Acquisition Tax (FC) |
Num |
19.6 |
- |
|
|
|
| AqcsTaxSC |
Acquisition Tax (SC) |
Num |
19.6 |
- |
|
|
|
| CashDiscPr |
Cash Discount Percentage |
Num |
19.6 |
- |
|
|
|
| CashDiscnt |
Cash Discount |
Num |
19.6 |
- |
|
|
|
| CashDiscFC |
Cash Discount (FC) |
Num |
19.6 |
- |
|
|
|
| CashDiscSC |
Cash Discount (SC) |
Num |
19.6 |
- |
|
|
|
| ShipToCode |
Ship-to Code |
nVarChar |
50 |
- |
|
|
|
| LicTradNum |
Licensed Dealer No. |
nVarChar |
32 |
- |
|
|
|
| PaymentRef |
Payment Reference No. |
nVarChar |
27 |
- |
|
|
|
| WTSum |
WTax Amount |
Num |
19.6 |
- |
|
|
|
| WTSumFC |
WTax Amount (FC) |
Num |
19.6 |
- |
|
|
|
| WTSumSC |
WTax Amount (SC) |
Num |
19.6 |
- |
|
|
|
| RoundDif |
Rounding Diff. Amount |
Num |
19.6 |
- |
|
|
|
| RoundDifFC |
Rounding Diff. Amount (FC) |
Num |
19.6 |
- |
|
|
|
| RoundDifSy |
Rounding Diff. Amount (SC) |
Num |
19.6 |
- |
|
|
|
| CheckDigit |
Control Digit |
VarChar |
1 |
- |
|
|
|
| Form1099 |
1099 Form |
Int |
11 |
OTNN |
|
|
|
| Box1099 |
1099 Box |
nVarChar |
20 |
- |
|
|
|
| submitted |
Submitted |
VarChar |
1 |
- |
N |
Y |
Yes |
| |
|
|
|
|
|
N |
No |
| PoPrss |
PO Process |
VarChar |
1 |
- |
N |
Y |
Yes |
| |
|
|
|
|
|
N |
No |
| Rounding |
Rounding |
VarChar |
1 |
- |
N |
Y |
Yes |
| |
|
|
|
|
|
N |
No |
| RevisionPo |
Split PO |
VarChar |
1 |
- |
N |
Y |
Yes |
| |
|
|
|
|
|
N |
No |
| Segment |
Segment |
Int |
6 |
- |
0 |
|
|
| ReqDate |
Required Date |
Date |
8 |
- |
|
|
|
| CancelDate |
Cancelation Date |
Date |
8 |
- |
|
|
|
| PickStatus |
Pick Status |
VarChar |
1 |
- |
N |
Y |
Yes |
| |
|
|
|
|
|
N |
No |
| Pick |
Pick |
VarChar |
1 |
- |
N |
Y |
Yes |
| |
|
|
|
|
|
N |
No |
| BlockDunn |
Block Dunning |
VarChar |
1 |
- |
N |
Y |
Yes |
| |
|
|
|
|
|
N |
No |
| PeyMethod |
Payment Method |
nVarChar |
15 |
OPYM |
|
|
|
| PayBlock |
Payment Block |
VarChar |
1 |
- |
N |
Y |
Yes |
| |
|
|
|
|
|
N |
No |
| PayBlckRef |
Payment Block Abs Entry |
Int |
11 |
OPYB |
|
|
|
| MaxDscn |
Maximum Discount |
VarChar |
1 |
- |
N |
Y |
Yes |
| |
|
|
|
|
|
N |
No |
| Reserve |
Reserve |
VarChar |
1 |
- |
N |
Y |
Yes |
| |
|
|
|
|
|
N |
No |
| Max1099 |
Max. 1099 Amount |
Num |
19.6 |
- |
|
|
|
| CntrlBnk |
Central Bank Indicator |
nVarChar |
15 |
OCBI |
|
|
|
| PickRmrk |
Pick Remarks |
nVarChar |
254 |
- |
|
|
|
| ISRCodLine |
ISR Coding Line |
nVarChar |
53 |
- |
|
|
|
| ExpAppl |
Exp applied |
Num |
19.6 |
- |
|
|
|
| ExpApplFC |
Exp applied FC |
Num |
19.6 |
- |
|
|
|
| ExpApplSC |
Exp applied DC |
Num |
19.6 |
- |
|
|
|
| Project |
Project Code |
nVarChar |
20 |
OPRJ |
|
|
|
| DeferrTax |
Deferred Tax |
VarChar |
1 |
- |
|
Y |
Yes |
| |
|
|
|
|
|
N |
No |
| LetterNum |
Tax Exemption Letter No. |
nVarChar |
50 |
- |
|
|
|
| FromDate |
Exemption Validity Date From |
Date |
8 |
- |
|
|
|
| ToDate |
Exemption Validity Date To |
Date |
8 |
- |
|
|
|
| WTApplied |
Applied WTax |
Num |
19.6 |
- |
|
|
|
| WTAppliedF |
Applied WTax (FC) |
Num |
19.6 |
- |
|
|
|
| BoeReserev |
Bill of Exchange Reserved |
VarChar |
1 |
- |
N |
Y |
Yes |
| |
|
|
|
|
|
N |
No |
| AgentCode |
Agent Code |
nVarChar |
32 |
OAGP |
|
|
|
| WTAppliedS |
Applied WTax (SC) |
Num |
19.6 |
- |
|
|
|
| EquVatSum |
Total Equalization Tax |
Num |
19.6 |
- |
|
|
|
| EquVatSumF |
Total Equalization Tax (FC) |
Num |
19.6 |
- |
|
|
|
| EquVatSumS |
Total Equalization Tax (SC) |
Num |
19.6 |
- |
|
|
|
| Installmnt |
No. of Installments |
Int |
6 |
- |
1 |
|
|
| VATFirst |
Apply Tax on 1st Installment |
VarChar |
1 |
- |
|
Y |
Yes |
| |
|
|
|
|
|
N |
No |
| |
|
|
|
|
|
T |
Tax Only |
| NnSbAmnt |
WTax Non-Subject Amount |
Num |
19.6 |
- |
|
|
|
| NnSbAmntSC |
WTax Non-Subject Amount (SC) |
Num |
19.6 |
- |
|
|
|
| NbSbAmntFC |
WTax Non-Subject Amount (FC) |
Num |
19.6 |
- |
|
|
|
| ExepAmnt |
Withholding Tax Exempt Amount |
Num |
19.6 |
- |
|
|
|
| ExepAmntSC |
WTax Exempt Amount (SC) |
Num |
19.6 |
- |
|
|
|
| ExepAmntFC |
WTax Exempt Amount (FC) |
Num |
19.6 |
- |
|
|
|
| VatDate |
Document Date |
Date |
8 |
- |
|
|
|
| CorrExt |
External Corrected Document No. |
nVarChar |
25 |
- |
|
|
|
| CorrInv |
Internal Corrected Document No. |
Int |
11 |
- |
|
|
|
| NCorrInv |
Next Correcting Document |
Int |
11 |
- |
|
|
|
| CEECFlag |
Block Creation Target Corr Inv |
VarChar |
1 |
- |
N |
N |
No |
| |
|
|
|
|
|
Y |
Yes |
| BaseAmnt |
Base Amount |
Num |
19.6 |
- |
|
|
|
| BaseAmntSC |
Base Amount (SC) |
Num |
19.6 |
- |
|
|
|
| BaseAmntFC |
Base Amount (FC) |
Num |
19.6 |
- |
|
|
|
| CtlAccount |
Control Account |
nVarChar |
15 |
OACT |
|
|
|
| BPLId |
Branch |
Int |
11 |
OBPL |
|
|
|
| BPLName |
Branch Name |
nVarChar |
200 |
- |
|
|
|
| VATRegNum |
VAT Registration Number |
nVarChar |
32 |
- |
|
|
|
| TxInvRptNo |
Tax Invoice Rpt Number |
nVarChar |
10 |
- |
|
|
|
| TxInvRptDt |
Tax Invoice Rpt Date |
Date |
8 |
- |
|
|
|
| KVVATCode |
VAT Code for Tax Invoice Rpt |
Text |
16 |
- |
|
|
|
| WTDetails |
WTax Details |
nVarChar |
100 |
- |
|
|
|
| SumAbsId |
Summary VAT Abstract ID |
Int |
11 |
OSRT |
-1 |
|
|
| SumRptDate |
Summary VAT Report Date |
Date |
8 |
- |
|
|
|
| PIndicator |
Period Indicator |
nVarChar |
10 |
OPID |
' ' |
|
|
| ManualNum |
Manual Number |
nVarChar |
20 |
- |
|
|
|
| UseShpdGd |
Use Shipped Goods Account |
VarChar |
1 |
- |
N |
N |
No |
| |
|
|
|
|
|
Y |
Yes |
| BaseVtAt |
BPL ID Assigned to Invoice |
Num |
19.6 |
- |
|
|
|
| BaseVtAtSC |
BPL Name |
Num |
19.6 |
- |
|
|
|
| BaseVtAtFC |
Tax Reg. Number |
Num |
19.6 |
- |
|
|
|
| NnSbVAt |
Tax Invoice Rpt Number |
Num |
19.6 |
- |
|
|
|
| NnSbVAtSC |
Tax Invoice Rpt Date |
Num |
19.6 |
- |
|
|
|
| NbSbVAtFC |
WTax Amount - VAT-exempt (FC) |
Num |
19.6 |
- |
|
|
|
| ExptVAt |
WTax Exempt VAT Amount |
Num |
19.6 |
- |
|
|
|
| ExptVAtSC |
WTax Exempt VAT Amount (SC) |
Num |
19.6 |
- |
|
|
|
| ExptVAtFC |
Withholding Tax Details |
Num |
19.6 |
- |
|
|
|
| LYPmtAt |
Last Year's Payments |
Num |
19.6 |
- |
|
|
|
| LYPmtAtSC |
Last Years Payments (SC) |
Num |
19.6 |
- |
|
|
|
| LYPmtAtFC |
Summary Tax Report Date |
Num |
19.6 |
- |
|
|
|
| ExpAnSum |
Period Indicator |
Num |
19.6 |
- |
|
|
|
| ExpAnSys |
Manual Number |
Num |
19.6 |
- |
|
|
|
| ExpAnFrgn |
Use Shipped Goods Account |
Num |
19.6 |
- |
|
|
|
| DocSubType |
VAT Code for Tax Invoice Rpt |
nVarChar |
2 |
- |
-- |
-- |
A/P Down Payment |
| DpmStatus |
Summary VAT Abstract ID |
VarChar |
1 |
- |
O |
O |
Open |
| |
|
|
|
|
|
C |
Closed |
| DpmAmnt |
Down Payment Amount LC |
Num |
19.6 |
- |
|
|
|
| DpmAmntSC |
Down Payment Amount SC |
Num |
19.6 |
- |
|
|
|
| DpmAmntFC |
Down Payment Amount FC |
Num |
19.6 |
- |
|
|
|
| DpmDrawn |
Drawn to Down Payment |
VarChar |
1 |
- |
N |
N |
No |
| |
|
|
|
|
|
Y |
Yes |
| DpmPrcnt |
Down Payment Percent |
Num |
19.6 |
- |
|
|
|
| PaidSum |
Total Paid Sum |
Num |
19.6 |
- |
|
|
|
| PaidSumFc |
Total Paid Sum (FC) |
Num |
19.6 |
- |
|
|
|
| PaidSumSc |
Total Paid Sum (SC) |
Num |
19.6 |
- |
|
|
|
| FolioPref |
Folio Prefix String |
nVarChar |
4 |
- |
|
|
|
| FolioNum |
Folio Number |
Int |
11 |
- |
|
|
|
| DpmAppl |
Down Payment Applied LC |
Num |
19.6 |
- |
|
|
|
| DpmApplFc |
Down Payment Applied FC |
Num |
19.6 |
- |
|
|
|
| DpmApplSc |
Down Payment Applied SC |
Num |
19.6 |
- |
|
|
|
| LPgFolioN |
Folio No. for Last Page in Doc. |
Int |
11 |
- |
|
|
|
| Header |
Header |
Text |
16 |
- |
|
|
|
| Footer |
Footer |
Text |
16 |
- |
|
|
|
| Posted |
Down Payment Was Posted |
VarChar |
1 |
- |
Y |
Y |
Yes |
| |
|
|
|
|
|
N |
No |
| OwnerCode |
Document Owner |
Int |
11 |
OHEM |
|
|
|
| BPChCode |
BP Channel Code |
nVarChar |
15 |
OCRD |
|
|
|
| BPChCntc |
BP Channel Contact Person |
Int |
11 |
OCPR |
|
|
|
| PayToCode |
Pay To |
nVarChar |
50 |
- |
|
|
|
| IsPaytoBnk |
Is Pay to Bank |
VarChar |
1 |
- |
|
N |
No |
| |
|
|
|
|
|
Y |
Yes |
| BnkCntry |
Pay to Bank Country/Region |
nVarChar |
3 |
OCRY |
|
|
|
| BankCode |
Pay to Bank Code |
nVarChar |
30 |
- |
|
|
|
| BnkAccount |
Pay to Bank Account No. |
nVarChar |
50 |
- |
|
|
|
| BnkBranch |
Pay to Bank Branch |
nVarChar |
50 |
- |
|
|
|
| isIns |
Reserve Invoice |
VarChar |
1 |
- |
N |
Y |
Yes |
| |
|
|
|
|
|
N |
No |
| TrackNo |
Tracking Number |
nVarChar |
30 |
- |
|
|
|
| VersionNum |
Version Number |
nVarChar |
13 |
- |
|
|
|
| LangCode |
Language Code |
Int |
11 |
OLNG |
|
|
|
| BPNameOW |
BP_NAME_OVERWRITTEN |
VarChar |
1 |
- |
N |
Y |
Yes |
| |
|
|
|
|
|
N |
No |
| BillToOW |
BILL_TO_OVERWRITTEN |
VarChar |
1 |
- |
N |
Y |
Yes |
| |
|
|
|
|
|
N |
No |
| ShipToOW |
SHIP_TO_OVERWRITTEN |
VarChar |
1 |
- |
N |
Y |
Yes |
| |
|
|
|
|
|
N |
No |
| RetInvoice |
Credit Memo |
VarChar |
1 |
- |
N |
Y |
Yes |
| |
|
|
|
|
|
N |
No |
| ClsDate |
Document Closing Date |
Date |
8 |
- |
|
|
|
| MInvNum |
Monthly Invoice No. |
Int |
11 |
- |
|
|
|
| MInvDate |
Monthly Invoice Date |
Date |
8 |
- |
|
|
|
| SeqCode |
Sequence Code |
Int |
6 |
- |
|
|
|
| Serial |
Serial Number |
Int |
11 |
- |
|
|
|
| SeriesStr |
Series String |
nVarChar |
3 |
- |
|
|
|
| SubStr |
Subseries String |
nVarChar |
3 |
- |
|
|
|
| Model |
Nota Fiscal Model |
nVarChar |
6 |
ONFM |
0 |
|
|
| TaxOnExp |
Tax On Expenses Sum |
Num |
19.6 |
- |
|
|
|
| TaxOnExpFc |
Tax On Expenses Sum (FC) |
Num |
19.6 |
- |
|
|
|
| TaxOnExpSc |
Tax On Expenses Sum (SC) |
Num |
19.6 |
- |
|
|
|
| TaxOnExAp |
Tax On Expenses Applied |
Num |
19.6 |
- |
|
|
|
| TaxOnExApF |
Tax on Freight Applied (FC) |
Num |
19.6 |
- |
|
|
|
| TaxOnExApS |
Tax on Freight Applied (SC) |
Num |
19.6 |
- |
|
|
|
| LastPmnTyp |
Last Payment Type |
VarChar |
1 |
- |
|
R |
Receipt |
| |
|
|
|
|
|
V |
Vendor Payment |
| LndCstNum |
Landed Cost Number |
Int |
11 |
- |
|
|
|
| UseCorrVat |
Use Correction VAT Group |
VarChar |
1 |
- |
N |
N |
No |
| |
|
|
|
|
|
Y |
Yes |
| BlkCredMmo |
Block Creating Credit Memo Tgt |
VarChar |
1 |
- |
N |
N |
No |
| |
|
|
|
|
|
Y |
Yes |
| OpenForLaC |
Open for Landed Costs |
VarChar |
1 |
- |
Y |
Y |
Open for Landed Costs |
| |
|
|
|
|
|
N |
Closed for Landed Costs |
| Excised |
Excised |
VarChar |
1 |
- |
O |
O |
Open |
| |
|
|
|
|
|
C |
Close |
| ExcRefDate |
Excise Ref. Date |
Date |
8 |
- |
|
|
|
| ExcRmvTime |
Excise Removal Time |
nVarChar |
8 |
- |
|
|
|
| SrvGpPrcnt |
Gross Profit Prcnt of Service |
Num |
19.6 |
- |
100 |
|
|
| DepositNum |
Deposit Number |
Int |
11 |
OVPM |
|
|
|
| CertNum |
Certificate Number |
nVarChar |
31 |
- |
|
|
|
| DutyStatus |
Duty Status |
VarChar |
1 |
- |
Y |
Y |
With Payment of Duty |
| |
|
|
|
|
|
N |
Without Payment of Duty |
| AutoCrtFlw |
Auto Create Follow-up Document |
VarChar |
1 |
- |
N |
N |
No |
| |
|
|
|
|
|
Y |
Yes |
| FlwRefDate |
Follow-up Document Ref. Date |
Date |
8 |
- |
|
|
|
| FlwRefNum |
Follow-up Document Ref. Number |
nVarChar |
100 |
- |
|
|
|
| VatJENum |
VAT Journal Entry Number |
Int |
11 |
- |
-1 |
|
|
| DpmVat |
Down Payment Tax LC |
Num |
19.6 |
- |
|
|
|
| DpmVatFc |
Down Payment Tax FC |
Num |
19.6 |
- |
|
|
|
| DpmVatSc |
Down Payment Tax SC |
Num |
19.6 |
- |
|
|
|
| DpmAppVat |
Down Payment Applied Tax LC |
Num |
19.6 |
- |
|
|
|
| DpmAppVatF |
Down Payment Applied Tax FC |
Num |
19.6 |
- |
|
|
|
| DpmAppVatS |
Down Payment Applied Tax SC |
Num |
19.6 |
- |
|
|
|
| InsurOp347 |
347 Insurance Operation |
VarChar |
1 |
- |
N |
N |
No |
| |
|
|
|
|
|
Y |
Yes |
| IgnRelDoc |
Ignore Relevant Doc on Archive |
VarChar |
1 |
- |
N |
N |
No |
| |
|
|
|
|
|
Y |
Yes |
| 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 Country/Region of Residence |
| |
|
|
|
|
|
5 |
Certificate of Fiscal Residence |
| |
|
|
|
|
|
6 |
Other Document |
| |
|
|
|
|
|
7 |
Not Registered |
| Checker |
Checker |
Int |
11 |
OHEM |
|
|
|
| Payee |
Payee |
Int |
11 |
OHEM |
|
|
|
| CopyNumber |
Copy Number |
Int |
11 |
- |
0 |
|
|
| SSIExmpt |
SSI Exemption |
VarChar |
1 |
- |
|
Y |
Yes |
| |
|
|
|
|
|
N |
No |
| PQTGrpSer |
Pur Quotation Group Series |
Int |
11 |
- |
|
|
|
| PQTGrpNum |
Pur Quotation Group Number |
Int |
11 |
- |
|
|
|
| PQTGrpHW |
Pur Quotation Group Manual |
VarChar |
1 |
- |
N |
Y |
Yes |
| |
|
|
|
|
|
N |
No |
| ReopOriDoc |
Reopen Origin. Order by Return |
VarChar |
1 |
- |
|
Y |
Yes |
| |
|
|
|
|
|
N |
No |
| ReopManCls |
Reop. Man. Closed/Canc. Orders |
VarChar |
1 |
- |
|
Y |
Yes |
| |
|
|
|
|
|
N |
No |
| DocManClsd |
Document Was Closed Manually |
VarChar |
1 |
- |
N |
Y |
Yes |
| |
|
|
|
|
|
N |
No |
| |
|
|
|
|
|
U |
Unknown |
| ClosingOpt |
Closing Option |
Int |
6 |
- |
1 |
|
|
| SpecDate |
Posting Date Specified by User |
Date |
8 |
- |
|
|
|
| Ordered |
Payment Ordered |
VarChar |
1 |
- |
N |
Y |
Yes |
| |
|
|
|
|
|
N |
No |
| NTSApprov |
NTS Approved |
VarChar |
1 |
- |
N |
N |
No |
| |
|
|
|
|
|
Y |
Yes |
| NTSWebSite |
E-Tax Web Site |
Int |
6 |
OTWS |
|
|
|
| NTSeTaxNo |
E-Tax Number |
nVarChar |
50 |
- |
|
|
|
| NTSApprNo |
NTS Approval Number |
nVarChar |
50 |
- |
|
|
|
| PayDuMonth |
Start From |
VarChar |
1 |
- |
|
E |
Month End |
| |
|
|
|
|
|
H |
Half Month |
| |
|
|
|
|
|
Y |
Month Start |
| |
|
|
|
|
|
N |
|
| ExtraMonth |
Number of Additional Months |
Int |
6 |
- |
|
|
|
| ExtraDays |
Number of Additional Days |
Int |
6 |
- |
|
|
|
| CdcOffset |
Cash Discount Offset |
Int |
6 |
- |
0 |
|
|
| SignMsg |
Signature Input Message |
Text |
16 |
- |
|
|
|
| SignDigest |
Signature Digest |
Text |
16 |
- |
|
|
|
| CertifNum |
Certification Number |
nVarChar |
50 |
- |
|
|
|
| KeyVersion |
Private Key Version |
Int |
11 |
- |
|
|
|
| EDocGenTyp |
Electr. Doc. Generation Type |
VarChar |
1 |
- |
N |
N |
Not Relevant |
| |
|
|
|
|
|
G |
Generate |
| |
|
|
|
|
|
L |
Generate - Later |
| |
|
|
|
|
|
S |
Send |
| |
|
|
|
|
|
R |
Send - Later |
| ESeries |
Electronic Series |
Int |
6 |
NNM4 |
|
|
|
| EDocNum |
Electronic Document Number |
nVarChar |
50 |
- |
|
|
|
| EDocExpFrm |
Electronic Doc. Export Format |
Int |
11 |
- |
|
|
|
| OnlineQuo |
Create Online Quotation |
VarChar |
1 |
- |
N |
Y |
Yes |
| |
|
|
|
|
|
N |
No |
| POSEqNum |
POS Equipment Number |
nVarChar |
20 |
- |
|
|
|
| POSManufSN |
POS Manufacturer Serial Number |
nVarChar |
20 |
- |
|
|
|
| POSCashN |
POS Cashier Number |
Int |
11 |
- |
|
|
|
| EDocStatus |
Electronic Document Status |
VarChar |
1 |
- |
C |
N |
New |
| |
|
|
|
|
|
P |
Pending |
| |
|
|
|
|
|
S |
Sent |
| |
|
|
|
|
|
E |
Error |
| |
|
|
|
|
|
C |
OK |
| EDocCntnt |
Electronic Document Content |
Text |
16 |
- |
|
|
|
| EDocProces |
Electronic Document Process |
VarChar |
1 |
- |
C |
C |
CFD |
| |
|
|
|
|
|
I |
CFDI |
| EDocErrCod |
Electronic Document Error Code |
nVarChar |
50 |
- |
|
|
|
| EDocErrMsg |
Electronic Document Error Msg |
Text |
16 |
- |
|
|
|
| EDocCancel |
Electronic Document - Canceled |
VarChar |
1 |
- |
N |
N |
No |
| |
|
|
|
|
|
Y |
Yes |
| EDocTest |
Electronic Document - Testing |
VarChar |
1 |
- |
N |
N |
No |
| |
|
|
|
|
|
Y |
Yes |
| EDocPrefix |
Electronic Document - Prefix |
nVarChar |
10 |
- |
|
|
|
| CUP |
Unique Code of Project |
Int |
11 |
OCUP |
|
|
|
| CIG |
Contract Code Identification |
Int |
11 |
OCIG |
|
|
|
| DpmAsDscnt |
Discount Document with Dpm |
VarChar |
1 |
- |
N |
N |
No |
| |
|
|
|
|
|
Y |
Yes |
| Attachment |
Attachment |
Text |
16 |
- |
|
|
|
| AtcEntry |
Attachment Entry |
Int |
11 |
- |
|
|
|
| SupplCode |
Supplementary Code |
nVarChar |
254 |
- |
|
|
|
| GTSRlvnt |
Relevant To GTS |
VarChar |
1 |
- |
N |
N |
No |
| |
|
|
|
|
|
Y |
Yes |
| BaseDisc |
Base Discount LC |
Num |
19.6 |
- |
|
|
|
| BaseDiscSc |
Base Discount SC |
Num |
19.6 |
- |
|
|
|
| BaseDiscFc |
Base Discount FC |
Num |
19.6 |
- |
|
|
|
| BaseDiscPr |
Base Discount Percentage |
Num |
19.6 |
- |
|
|
|
| CreateTS |
Creatn Time - Incl. Secs |
Int |
11 |
- |
|
|
|
| UpdateTS |
Update Full Time |
Int |
11 |
- |
|
|
|
| SrvTaxRule |
Apply Service Tax Rule |
VarChar |
1 |
- |
N |
Y |
Yes |
| |
|
|
|
|
|
N |
No |
| AnnInvDecR |
Annual Inv. Declaration Ref. |
Int |
11 |
- |
|
|
|
| Supplier |
Supplier |
nVarChar |
15 |
OCRD |
|
|
|
| Releaser |
Goods Distribution Approver |
Int |
11 |
OHEM |
|
|
|
| Receiver |
Goods Release Approver |
Int |
11 |
OHEM |
|
|
|
| ToWhsCode |
To Warehouse Code |
nVarChar |
8 |
OWHS |
|
|
|
| AssetDate |
Fixed Asset Value Date |
Date |
8 |
- |
|
|
|
| Requester |
User Requesting Goods |
nVarChar |
25 |
- |
|
|
|
| ReqName |
User Name |
nVarChar |
155 |
- |
|
|
|
| Branch |
Branch |
Int |
6 |
OUBR |
|
|
|
| Department |
Department |
Int |
6 |
OUDP |
|
|
|
| Email |
E-Mail |
nVarChar |
100 |
- |
|
|
|
| Notify |
Send Notification Needed |
VarChar |
1 |
- |
|
Y |
Yes |
| |
|
|
|
|
|
N |
No |
| ReqType |
Requester Type User/Employee |
Int |
11 |
- |
12 |
12 |
User |
| |
|
|
|
|
|
171 |
Employee |
| OriginType |
Document Origin |
VarChar |
1 |
- |
M |
M |
Manual |
| |
|
|
|
|
|
R |
MRP |
| |
|
|
|
|
|
S |
Sales Order |
| |
|
|
|
|
|
D |
Document Generation Wizard |
| IsReuseNum |
Is Reusing Document Number |
VarChar |
1 |
- |
N |
Y |
Yes |
| |
|
|
|
|
|
N |
No |
| IsReuseNFN |
Is Reusing Nota Fiscal Number |
VarChar |
1 |
- |
N |
Y |
Yes |
| |
|
|
|
|
|
N |
No |
| DocDlvry |
Document Delivery |
VarChar |
1 |
- |
|
0 |
None |
| |
|
|
|
|
|
1 |
Create Online Document |
| |
|
|
|
|
|
2 |
Post to Ariba Network |
| PaidDpm |
Paid by Down Payment |
Num |
19.6 |
- |
|
|
|
| PaidDpmF |
Paid by Down Payment (FC) |
Num |
19.6 |
- |
|
|
|
| PaidDpmS |
Paid by Down Payment (SC) |
Num |
19.6 |
- |
|
|
|
| EnvTypeNFe |
Environment Type NF-e |
Int |
11 |
OBNI |
-1 |
|
|
| AgrNo |
Agreement No. |
Int |
11 |
- |
|
|
|
| IsAlt |
Is Alteration |
VarChar |
1 |
- |
N |
Y |
Yes |
| |
|
|
|
|
|
N |
No |
| AltBaseTyp |
Alteration Base Type |
Int |
11 |
- |
-1 |
-1 |
|
| |
|
|
|
|
|
13 |
|
| |
|
|
|
|
|
18 |
|
| |
|
|
|
|
|
163 |
|
| |
|
|
|
|
|
165 |
|
| AltBaseEnt |
Alteration Base Entry |
Int |
11 |
- |
|
|
|
| AuthCode |
Authorization Code |
nVarChar |
250 |
- |
|
|
|
| StDlvDate |
Start Delivery Date |
Date |
8 |
- |
|
|
|
| StDlvTime |
Start Delivery Time |
Int |
11 |
- |
|
|
|
| EndDlvDate |
End Delivery Date |
Date |
8 |
- |
|
|
|
| EndDlvTime |
End Delivery Time |
Int |
11 |
- |
|
|
|
| VclPlate |
Vehicle Plate |
nVarChar |
20 |
- |
|
|
|
| ElCoStatus |
Elec. Comm. Status |
nVarChar |
10 |
- |
|
0 |
Approved |
| |
|
|
|
|
|
1 |
Pending Approval |
| |
|
|
|
|
|
2 |
Rejected |
| AtDocType |
AT Document Type |
nVarChar |
10 |
- |
|
|
|
| ElCoMsg |
Elec. Comm. Message |
nVarChar |
254 |
- |
|
|
|
| PrintSEPA |
Print SEPA Direct Debit Prenotification |
VarChar |
1 |
- |
N |
Y |
Yes |
| |
|
|
|
|
|
N |
No |
| FreeChrg |
Free of Charge BP |
Num |
19.6 |
- |
|
|
|
| FreeChrgFC |
Free of Charge BP FC |
Num |
19.6 |
- |
|
|
|
| FreeChrgSC |
Free of Charge BP SC |
Num |
19.6 |
- |
|
|
|
| NfeValue |
NF-e Value |
Num |
19.6 |
- |
|
|
|
| FiscDocNum |
Fiscal Document Number |
nVarChar |
100 |
- |
|
|
|
| RelatedTyp |
Related Type |
Int |
11 |
- |
-1 |
-1 |
|
| RelatedEnt |
Related Entry |
Int |
11 |
- |
|
|
|
| CCDEntry |
CCD Abs. Entry |
Int |
11 |
- |
|
|
|
| NfePrntFo |
NF-e Printing Format |
Int |
11 |
- |
0 |
0 |
No DANFE |
| |
|
|
|
|
|
1 |
Portrait |
| |
|
|
|
|
|
2 |
Landscape |
| |
|
|
|
|
|
3 |
Simplified |
| |
|
|
|
|
|
4 |
DANFE NFC-e |
| |
|
|
|
|
|
5 |
Mail |
| ZrdAbs |
POS Daily Summary Number |
Int |
11 |
OZRD |
|
|
|
| POSRcptNo |
POS Receipt Number |
Int |
11 |
- |
|
|
|
| FoCTax |
Free of Charge BP Tax |
Num |
19.6 |
- |
|
|
|
| FoCTaxFC |
Free of Charge BP Tax FC |
Num |
19.6 |
- |
|
|
|
| FoCTaxSC |
Free of Charge BP Tax SC |
Num |
19.6 |
- |
|
|
|
| TpCusPres |
Type of End-User Presence |
Int |
11 |
OBNI |
|
|
|
| ExcDocDate |
Excise Doc. Date |
Date |
8 |
- |
|
|
|
| FoCFrght |
Free of Charge Freight |
Num |
19.6 |
- |
|
|
|
| FoCFrghtFC |
Free of Charge Freight FC |
Num |
19.6 |
- |
|
|
|
| FoCFrghtSC |
Free of Charge Freight SC |
Num |
19.6 |
- |
|
|
|
| InterimTyp |
Interim Type |
Int |
6 |
- |
0 |
0 |
None |
| PTICode |
POI Code |
nVarChar |
5 |
OPTI |
|
|
|
| Letter |
Letter |
VarChar |
1 |
- |
|
|
|
| FolNumFrom |
Folio Number From |
Int |
11 |
- |
|
|
|
| FolNumTo |
Folio Number To |
Int |
11 |
- |
|
|
|
| FolSeries |
Folio Series |
Int |
11 |
OFNS |
|
|
|
| SplitTax |
Split Payment Tax |
Num |
19.6 |
- |
|
|
|
| SplitTaxFC |
Split Payment Tax FC |
Num |
19.6 |
- |
|
|
|
| SplitTaxSC |
Split Payment Tax SC |
Num |
19.6 |
- |
|
|
|
| ToBinCode |
To Bin Location |
nVarChar |
228 |
- |
|
|
|
| PriceMode |
Price Mode |
VarChar |
1 |
- |
|
N |
Net |
| |
|
|
|
|
|
G |
Gross |
| |
|
|
|
|
|
M |
Net and Gross |
| PoDropPrss |
PO Drop-Ship Process |
VarChar |
1 |
- |
N |
Y |
Yes |
| |
|
|
|
|
|
N |
No |
| PermitNo |
Permit Number |
nVarChar |
20 |
- |
|
|
|
| MYFtype |
MYF type |
nVarChar |
2 |
- |
|
S1 |
MYF Wholesale Sales |
| |
|
|
|
|
|
S2 |
Retail Sales |
| |
|
|
|
|
|
P1 |
MYF Wholesale Purchases |
| |
|
|
|
|
|
P3 |
Other Expense Transactions |
| DocTaxID |
Document Tax ID |
nVarChar |
32 |
- |
|
|
|
| DateReport |
Date of Reporting |
Date |
8 |
- |
|
|
|
| RepSection |
Reporting Section |
nVarChar |
3 |
- |
|
|
|
| ExclTaxRep |
Exclude from Control Statement |
VarChar |
1 |
- |
N |
Y |
Yes |
| |
|
|
|
|
|
N |
No |
| PosCashReg |
POS/Cash Register |
Int |
11 |
- |
|
|
|
| DmpTransID |
Trans ID for Down Payment |
nVarChar |
20 |
- |
|
|
|
| ECommerBP |
E-Commerce Operator |
nVarChar |
15 |
OCRD |
|
|
|
| EComerGSTN |
GST Regn No of E-Commerce |
nVarChar |
15 |
- |
|
|
|
| Revision |
Revision |
VarChar |
1 |
- |
N |
Y |
Yes |
| |
|
|
|
|
|
N |
No |
| RevRefNo |
Original Ref. No. |
nVarChar |
100 |
- |
|
|
|
| RevRefDate |
Original Ref. Date |
Date |
8 |
- |
|
|
|
| RevCreRefN |
Original Credit/Debit Ref. No. |
nVarChar |
100 |
- |
|
|
|
| RevCreRefD |
Orign Credit/Debit Ref. Date |
Date |
8 |
- |
|
|
|
| TaxInvNo |
Tax Invoice No. |
nVarChar |
100 |
- |
|
|
|
| FrmBpDate |
From Vendor Date |
Date |
8 |
- |
|
|
|
| GSTTranTyp |
GST Transaction Type |
nVarChar |
2 |
- |
|
-- |
Bill of Supply |
| |
|
|
|
|
|
GA |
GST Tax Invoice |
| |
|
|
|
|
|
GD |
GST Debit Memo |
| BaseType |
Base Document Type |
Int |
11 |
- |
-1 |
-1 |
|
| BaseEntry |
Base Document Internal Key |
Int |
11 |
- |
|
|
|
| ComTrade |
Commission Trade |
VarChar |
1 |
- |
E |
E |
|
| |
|
|
|
|
|
S |
Sales Agent |
| |
|
|
|
|
|
P |
Purchase Agent |
| |
|
|
|
|
|
C |
Consignor |
| UseBilAddr |
Determine GST by Using Bill to |
VarChar |
1 |
- |
|
Y |
Yes |
| |
|
|
|
|
|
N |
No |
| IssReason |
Reason for issuing note |
Int |
6 |
- |
1 |
1 |
Sales Return |
| |
|
|
|
|
|
2 |
Post sale discount |
| |
|
|
|
|
|
3 |
Deficiency in service |
| |
|
|
|
|
|
4 |
Correction in invoice |
| |
|
|
|
|
|
5 |
Change in POS |
| |
|
|
|
|
|
6 |
Finalization of Provisional Assessment |
| |
|
|
|
|
|
7 |
Others |
| ComTradeRt |
Commission Trade Return |
VarChar |
1 |
- |
N |
Y |
Yes |
| |
|
|
|
|
|
N |
No |
| SplitPmnt |
A/P Split Payment |
VarChar |
1 |
- |
N |
Y |
Yes |
| |
|
|
|
|
|
N |
No |
| SOIWizId |
SOI Wizard ID |
Int |
11 |
OSOI |
|
|
|
| SelfPosted |
Self Invoice Created [Yes/No] |
VarChar |
1 |
- |
N |
Y |
Yes |
| |
|
|
|
|
|
N |
No |
| EnBnkAcct |
Encryption of Pay to Bank Acct |
Text |
16 |
- |
|
|
|
| EncryptIV |
Encrypt IV |
nVarChar |
100 |
- |
|
|
|
| DPPStatus |
Data Protection Status |
VarChar |
1 |
- |
N |
N |
None |
| |
|
|
|
|
|
D |
Erased |
| SAPPassprt |
Extended SAP Passport |
Text |
16 |
- |
|
|
|
| EWBGenType |
E-Way Bill Generation Type |
VarChar |
1 |
- |
|
N |
Not Relevant |
| |
|
|
|
|
|
G |
Generate |
| |
|
|
|
|
|
L |
Generate - Later |
| CtActTax |
Customer Accounting Tax |
Num |
19.6 |
- |
|
|
|
| CtActTaxFC |
Customer Accounting Tax (FC) |
Num |
19.6 |
- |
|
|
|
| CtActTaxSC |
Customer Accounting Tax (SC) |
Num |
19.6 |
- |
|
|
|
| EDocType |
eDoc Type |
VarChar |
1 |
- |
F |
F |
FE |
| |
|
|
|
|
|
C |
FCE |
| QRCodeSrc |
QR Code Source |
Text |
16 |
- |
|
|
|
| AggregDoc |
Aggregate Document |
VarChar |
1 |
- |
N |
Y |
Yes |
| |
|
|
|
|
|
N |
No |
| DataVers |
Data Version |
Int |
11 |
- |
1 |
|
|
| ShipState |
Shipment State Code |
nVarChar |
3 |
OCST |
|
|
|
| ShipPlace |
Shipment Place Name |
nVarChar |
60 |
- |
|
|
|
| CustOffice |
Customs Office Name |
nVarChar |
60 |
- |
|
|
|
| FCI |
FCI Number |
nVarChar |
36 |
- |
|
|
|
| NnSbCuAmnt |
WTax Non-Subject CU Amount |
Num |
19.6 |
- |
|
|
|
| NnSbCuSC |
WTax Non-Subject CU Amount SC |
Num |
19.6 |
- |
|
|
|
| NnSbCuFC |
WTax Non-Subject CU Amount FC |
Num |
19.6 |
- |
|
|
|
| ExepCuAmnt |
WTax Exempt CU Amount |
Num |
19.6 |
- |
|
|
|
| ExepCuSC |
WTax Exempt CU Amount SC |
Num |
19.6 |
- |
|
|
|
| ExepCuFC |
WTax Exempt CU Amount FC |
Num |
19.6 |
- |
|
|
|
| AddLegIn |
Additional Legal Information |
nVarChar |
100 |
- |
|
|
|
| LegTextF |
Legal Text Format |
Int |
11 |
OLTF |
|
|
|
| IndFinal |
Indicator for Final Consumer |
VarChar |
1 |
- |
N |
Y |
Yes |
| |
|
|
|
|
|
N |
No |
| DANFELgTxt |
DANFE Legal Text |
Text |
16 |
- |
|
|
|
| PostPmntWT |
Post Payment Withholding Tax |
VarChar |
1 |
- |
N |
N |
No |
| |
|
|
|
|
|
Y |
Yes |
| QRCodeSPGn |
QR Code Source Generated from Stored Procedure |
Text |
16 |
- |
|
|
|
| FCEPmnMean |
Use FCEs as Payment Means |
VarChar |
1 |
- |
N |
Y |
Yes |
| |
|
|
|
|
|
N |
No |
| ReqCode |
Requester Code |
nVarChar |
50 |
- |
|
|
|
| NotRel4MI |
Not Relevant for Monthly Invoice |
VarChar |
1 |
- |
N |
Y |
Yes |
| |
|
|
|
|
|
N |
No |
| Rel4PPTax |
Relevant for Plastic Packaging Tax |
VarChar |
1 |
- |
N |
Y |
Yes |
| |
|
|
|
|
|
N |
No |
| ConfrmedBy |
Confirmed By |
Int |
11 |
- |
|
|
|
| ConfrmedOn |
Confirmed On |
Date |
8 |
- |
|
|
|
| ReqID |
Requester ID |
Int |
11 |
- |
|
|
|
| NonDdAmt |
Non-Deductible Amount |
Num |
19.6 |
- |
|
|
|
| NonDdAmtSC |
Non-Deductible Amount (SC) |
Num |
19.6 |
- |
|
|
|
| NonDdAmtFC |
Non-Deductible Amount (FC) |
Num |
19.6 |
- |
|
|
|
| BookeTdsBP |
Book the eTDS to the Business Partner |
VarChar |
1 |
- |
N |
Y |
Yes |
| |
|
|
|
|
|
N |
No |
| AllocNum |
Allocation Number for IL |
nVarChar |
50 |
- |
|
|
|
| DPayToAddr |
Digital Pay To Address |
nVarChar |
50 |
- |
|
|
|
| DigPayment |
Digital Payments |
VarChar |
1 |
- |
N |
Y |
Yes |
| |
|
|
|
|
|
N |
No |