biuan SAP® BUSINESS ONE SDK
DTW A/R Down Payment - Installments
API Document Installments / Due Date
DPI6 - A/R Down Payment - Installments Table

SBO SQL database table details

FieldDescriptionTypeConstraintsSizeRelatedDefaultPrimary_KeyUnique
DocEntry KEY UNIQUEDocument Internal IDInt
11ODPI
A/R Down Payment
PRIMARYYes
InstlmntIDInstallment IDInt
6
1
ObjTypeObject TypenVarChar
20ADP1
Object Settings - History
203
LogInstancLog InstanceInt
11
0
DueDateDue DateDate
8
StatusInstallment StatusVarChar
O) Open
C) Closed
1
O
DunnLevelDunning LevelInt
11
0
InsTotalTotal InstallmentNum
20
InsTotalFCTotal Installment (FC)Num
20
InsTotalSyTotal Installment (SC)Num
20
PaidToDatePaid to DateNum
20
PaidFCPaid (FC)Num
20
PaidSysPaid (SC)Num
20
VatSumTotal TaxNum
20
VatSumFCTax Amount (FC)Num
20
VatSumSyTax Amount (SC)Num
20
VatPaidTax Paid to DateNum
20
VatPaidFCTax Paid (FC)Num
20
VatPaidSysTax Paid (SC)Num
20
TotalExpnsTotal Freight ChargesNum
20
TotalExpFCTotal Freight Charges (FC)Num
20
TotalExpSCTotal Freight Charges (SC)Num
20
ExpApplApplied Freight ChargesNum
20
ExpApplFCApplied Freight Charges (FC)Num
20
ExpApplSCApplied Freight Charges (SC)Num
20
WTSumWTax AmountNum
20
WTSumFCWTax Amount (FC)Num
20
WTSumSCWTax Amount (SC)Num
20
WTAppliedApplied WTaxNum
20
WTAppliedFApplied WTax (FC)Num
20
WTAppliedSApplied WTax (SC)Num
20
TotalBlckTotal Reserved AmountNum
20
TotalBlckFTotal Reserved Amount (FC)Num
20
TotalBlckSTotal Reserved Amount (SC)Num
20
VATBlckReserved Tax AmountNum
20
VATBlckFCReserved Tax Amount (FC)Num
20
VATBlckSCReserved Tax Amount (SC)Num
20
ExpnsBlckReserved Freight ChargesNum
20
ExpnsBlckFReserved Freight Charges (FC)Num
20
ExpnsBlckSReserved Freight Charges (SC)Num
20
WTBlockedReserved WTax AmountNum
20
WTBlockedFReserved WTax Amount (FC)Num
20
WTBlockedSReserved WTax Amount (SC)Num
20
InstPrcntInstallment %Num
20
DunWizBlckWizard dunning blockVarChar
N) No
Y) Yes
1
N
DunDateLast Dunning DateDate
8
PaidPaidNum
20
PaidFrgnPaid (FC)Num
20
PaidScPaid (SC)Num
20
reservedReservedVarChar
N) No
Y) Yes
1
N
TaxOnExpTax on ExpensesNum
20
TaxOnExpFcTax on Expenses (FC)Num
20
TaxOnExpScTax on Expenses (SC)Num
20
TaxOnExpApApplied Tax on ExpensesNum
20
TaxOnExApFApplied Tax on Expenses (FC)Num
20
TaxOnExApSApplied Tax on Expenses (SC)Num
20
TaxOnExBloReserved Tax on Freight AmountNum
20
TaxOnExBlFReserved Tax on Freight Amt FCNum
20
TaxOnExBlSReserved Tax on Freight Amt SCNum
20
LvlUpdDateDunning Level Update DateDate
8
OrderedPayment OrderedVarChar
Y) Yes
N) No
1
N
PaidDpmPaid by Down PaymentNum
20
PaidDpmFcPaid by Down Payment (FC)Num
20
PaidDpmScPaid by Down Payment (SC)Num
20

Table relationship map

SELECT statement

SELECT DPI6.DocEntry AS 'Document Internal ID', DPI6.InstlmntID AS 'Installment ID', DPI6.ObjType AS 'Object Type', DPI6.LogInstanc AS 'Log Instance', DPI6.DueDate AS 'Due Date', DPI6.Status AS 'Installment Status', DPI6.DunnLevel AS 'Dunning Level', DPI6.InsTotal AS 'Total Installment', DPI6.InsTotalFC AS 'Total Installment (FC)', DPI6.InsTotalSy AS 'Total Installment (SC)', DPI6.PaidToDate AS 'Paid to Date', DPI6.PaidFC AS 'Paid (FC)', DPI6.PaidSys AS 'Paid (SC)', DPI6.VatSum AS 'Total Tax', DPI6.VatSumFC AS 'Tax Amount (FC)', DPI6.VatSumSy AS 'Tax Amount (SC)', DPI6.VatPaid AS 'Tax Paid to Date', DPI6.VatPaidFC AS 'Tax Paid (FC)', DPI6.VatPaidSys AS 'Tax Paid (SC)', DPI6.TotalExpns AS 'Total Freight Charges', DPI6.TotalExpFC AS 'Total Freight Charges (FC)', DPI6.TotalExpSC AS 'Total Freight Charges (SC)', DPI6.ExpAppl AS 'Applied Freight Charges', DPI6.ExpApplFC AS 'Applied Freight Charges (FC)', DPI6.ExpApplSC AS 'Applied Freight Charges (SC)', DPI6.WTSum AS 'WTax Amount', DPI6.WTSumFC AS 'WTax Amount (FC)', DPI6.WTSumSC AS 'WTax Amount (SC)', DPI6.WTApplied AS 'Applied WTax', DPI6.WTAppliedF AS 'Applied WTax (FC)', DPI6.WTAppliedS AS 'Applied WTax (SC)', DPI6.TotalBlck AS 'Total Reserved Amount', DPI6.TotalBlckF AS 'Total Reserved Amount (FC)', DPI6.TotalBlckS AS 'Total Reserved Amount (SC)', DPI6.VATBlck AS 'Reserved Tax Amount', DPI6.VATBlckFC AS 'Reserved Tax Amount (FC)', DPI6.VATBlckSC AS 'Reserved Tax Amount (SC)', DPI6.ExpnsBlck AS 'Reserved Freight Charges', DPI6.ExpnsBlckF AS 'Reserved Freight Charges (FC)', DPI6.ExpnsBlckS AS 'Reserved Freight Charges (SC)', DPI6.WTBlocked AS 'Reserved WTax Amount', DPI6.WTBlockedF AS 'Reserved WTax Amount (FC)', DPI6.WTBlockedS AS 'Reserved WTax Amount (SC)', DPI6.InstPrcnt AS 'Installment %', DPI6.DunWizBlck AS 'Wizard dunning block', DPI6.DunDate AS 'Last Dunning Date', DPI6.Paid AS 'Paid', DPI6.PaidFrgn AS 'Paid (FC)', DPI6.PaidSc AS 'Paid (SC)', DPI6.reserved AS 'Reserved', DPI6.TaxOnExp AS 'Tax on Expenses', DPI6.TaxOnExpFc AS 'Tax on Expenses (FC)', DPI6.TaxOnExpSc AS 'Tax on Expenses (SC)', DPI6.TaxOnExpAp AS 'Applied Tax on Expenses', DPI6.TaxOnExApF AS 'Applied Tax on Expenses (FC)', DPI6.TaxOnExApS AS 'Applied Tax on Expenses (SC)', DPI6.TaxOnExBlo AS 'Reserved Tax on Freight Amount', DPI6.TaxOnExBlF AS 'Reserved Tax on Freight Amt FC', DPI6.TaxOnExBlS AS 'Reserved Tax on Freight Amt SC', DPI6.LvlUpdDate AS 'Dunning Level Update Date', DPI6.Ordered AS 'Payment Ordered', DPI6.PaidDpm AS 'Paid by Down Payment', DPI6.PaidDpmFc AS 'Paid by Down Payment (FC)', DPI6.PaidDpmSc AS 'Paid by Down Payment (SC)' FROM DPI6 AS DPI6

Related information


 v9.0  Due Date DueDate Property· Table: DPI6
Returns or sets the due date of the installment. Field name: DueDate
· Table: DRF6 DPO6 PCH6 CPI6 CPV6 DPI6 INV6 CSI6 CSV6    Parent: Document Installments Document_Installments Object· Table: DRF6 DPO6 PCH6 CPI6 CPV6 DPI6 INV6 CSI6 CSV6
A/R Down Payment ODPI SQL Table

Object Settings - History ADP1 SQL Table



SAP® Business One is the trademark(s) or registered trademark(s) of SAP AG in Germany and in several other countries. Contact
This website is not affiliated with, maintained, authorized, endorsed or sponsored by SAP AG or any of its affiliates