A/R Credit Memo - SAP B1 SDK Help

Table Name: ORIN

Table Description: A/R Credit Memo

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
						C	Cancellation
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	14	14	A/R Credit Memo
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 in 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 in FC	Num	19.6	-
GrosProfit	Gross Profit	Num	19.6	-
GrosProfFC	Gross Profit in 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	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	Sales 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 Unit of Measure	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 in 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	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	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	WT 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	OVRT
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	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	Num	19.6	-
ExptVAt	WTax Exempted VAT Amount	Num	19.6	-
ExptVAtSC	WTax Exempted 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/R Credit Memo
						GA	GST Tax Invoice
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	OINV
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
						24	Incoming Payment
						46	Outgoing Payments
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
						1	Exchange Rate Interim Document
						2	Cash Discount Interim Document
PTICode	POI Code	nVarChar	5	OPTI
Letter	Letter	VarChar	1	-		A	A
						B	B
						C	C
						E	E
						M	M
						R	R
						T	T
						X	X
						-	-
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	No	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
FOL_SERIES	No	FolSeries
PROJECT	No	Project