📚 SAP Business One SDK Help

Table Name: OPOR

Table Description: Purchase Order

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 22 22 Purchase Order
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 in 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 -      
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 Landed Costs Internal ID 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 Warehouse 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 in SC Num 19.6 -      
DocTotalSy Document Total in SC Num 19.6 -      
PaidSys Paid in SC Num 19.6 -      
FatherType Parent Summary Type VarChar 1 - P P Payment Consolidation
            D Delivery Consolidation
GrosProfSy Gross Profit in 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 Volume UoM 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 Corrected 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 in 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 -      
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 Withholding Tax 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 Withholding Tax 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
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 (FC) Num 19.6 -      
ExepAmntFC WTax Exempt Amount (FC) Num 19.6 -      
VatDate VAT 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 Withholding Tax Details nVarChar 100 -      
SumAbsId Summary VAT Abstract ID Int 11 - -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 - -- -- Purchase Order
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 -      
DepositNum Deposit Number Int 11 -      
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 Selected Date
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
            B Blocked
            U Unblocked
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
OperProfit Operating Profit Num 19.6 -      
OperProfFC Operating Profit (FC) Num 19.6 -      
OperProfSy Operating Profit (SC) Num 19.6 -      
NetIncome Net Income Num 19.6 -      
NetIncomFC Net Income (FC) Num 19.6 -      
NetIncomSy Net Income (SC) Num 19.6 -      
PDueMonEnd End On VarChar 1 -   E End of Month
            H Middle of Month
            Y Start of Month
            N None
RShipToCod Ship-to Code for Return nVarChar 50 -      
Address3 Ship To for Return nVarChar 254 -      
RShipToOW Ship-to Address Overwritten for Return VarChar 1 - N Y Yes
            N No
EnLicTradN Encrypt TAX ID Number Text 16 -      
ListNum Price List No. Int 6 OPLN      
AplTaxOnFr Apply Only Taxes in First Installment VarChar 1 - N Y Yes
            N No
            T Tax Only
DocEmail E-Mail nVarChar 254 -      
SirenNo SIREN No. nVarChar 9 -      
SiretNo SIRET No. nVarChar 32 -      
CpyDtyStts Copy Duty Status from Base VarChar 1 - N Y Yes
            N No
RoutingCod Routing Code nVarChar 100 -      
DpmSpAmnt Down Payment Split Amount LC Num 19.6 -      
DpmSpAmtSC Down Payment Split Amount SC Num 19.6 -      
DpmSpAmtFC Down Payment Split Amount FC Num 19.6 -      
CmDpmPrcnt Credit Memo Down Payment Percent Num 19.6 -      
Suffix Suffix nVarChar 20 -      
Key Unique Field
PRIMARY Yes DocEntry
AT_CARD No NumAtCard
    CardCode
CUSTOMER No CardCode
NUM Yes DocNum
    Instance
    Segment
    DocSubType
    PIndicator
DOC_STATUS No DocStatus
    CANCELED
FTHR_CARD No FatherCard
    FatherType
SERIES No Series
OWNER_CODE No OwnerCode
DATE_PIND No DocDate
    PIndicator
ESERIES No ESeries
    EDocNum
PROJECT No Project