biuan SAP® BUSINESS ONE SDK
SQL Banking / Payment Terms
DTW Business Partners / Payment Terms Types
API OCTG / Payment Terms Types
OCTG - Payment Terms Table

SBO SQL database table details

FieldDescriptionTypeConstraintsSizeRelatedDefaultPrimary_KeyUnique
GroupNum KEY UNIQUEGroup NumberInt
6
PRIMARYYes
PymntGroup KEY UNIQUEPayment Terms Group NamenVarChar
100
ABS_ENTRYYes
PayDuMonthStart FromVarChar
E) Month End
H) Half Month
Y) Month Start
N)
1
N
ExtraMonthNumber of Additional MonthsInt
6
0
ExtraDaysNumber of Additional DaysInt
6
0
PaymntsNumNumber of PaymentsInt
6
CredLimitCredit LimitNum
20
VolumDscntGeneral Discount %Num
20
LatePyChrg% Interest on arrearsNum
20
ObligLimitLoad LimitNum
20
ListNumPrice List No.Int
6OPLN
Price Lists
PaymentsPartial PaymentVarChar
Y) Yes
N) No
1
N
NumOfPmntsNumber of PaymentsInt
6
1
Payment1First Partial PaymentNum
20
DataSourceData SourceVarChar
N) Unknown
I) Interface
U) Update
M) Import
O) DI API
A) Doc. Generation Wizard
D) Restore Wizard
P) Partner Implementation
T) Year Transfer
1
N
UserSignUser SignatureInt
6OUSR
Users
OpenRcptOpen Incoming PaymentVarChar
N) No
3) Cash
1) Checks
4) Credit
2) Bank Transfer
5) Bill of Exchange
1
N
DiscCodeDiscount CodenVarChar
20OCDC
Cash Discount
DunningCodDunning CodenVarChar
20ORIT
Dunning Interest Rate
BslineDateBase Row DateVarChar
P) Posting Date
S) System Date
T) Document Date
C) Closing Date
1
T
InstNumNo. of InstallmentsInt
6
TolDaysNo. of Tolerance DaysInt
6
VATFirstApply Tax on 1st InstallmentVarChar
Y) Yes
N) No
1
N
CrdMthdCredit MethodVarChar
F) First Installment
L) Last Installment
E) Equally
1
L

Table relationship map

SELECT statement

SELECT OCTG.GroupNum AS 'Group Number', OCTG.PymntGroup AS 'Payment Terms Group Name', OCTG.PayDuMonth AS 'Start From', OCTG.ExtraMonth AS 'Number of Additional Months', OCTG.ExtraDays AS 'Number of Additional Days', OCTG.PaymntsNum AS 'Number of Payments', OCTG.CredLimit AS 'Credit Limit', OCTG.VolumDscnt AS 'General Discount %', OCTG.LatePyChrg AS '% Interest on arrears', OCTG.ObligLimit AS 'Load Limit', OCTG.ListNum AS 'Price List No.', OCTG.Payments AS 'Partial Payment', OCTG.NumOfPmnts AS 'Number of Payments', OCTG.Payment1 AS 'First Partial Payment', OCTG.DataSource AS 'Data Source', OCTG.UserSign AS 'User Signature', OCTG.OpenRcpt AS 'Open Incoming Payment', OCTG.DiscCode AS 'Discount Code', OCTG.DunningCod AS 'Dunning Code', OCTG.BslineDate AS 'Base Row Date', OCTG.InstNum AS 'No. of Installments', OCTG.TolDays AS 'No. of Tolerance Days', OCTG.VATFirst AS 'Apply Tax on 1st Installment', OCTG.CrdMthd AS 'Credit Method' FROM OCTG AS OCTG

Related information


Payment Terms Types PaymentTermsTypes Object· Table: OCTG
PaymentTermsTypes is a business object that represents the types of payment terms in the Banking module. The payment terms define typical agreements that apply to transactions with customers and vendors. This object enables you to: Add a...

OCTG SQL Table

Cash Discount OCDC SQL Table

Dunning Interest Rate ORIT SQL Table

Price Lists OPLN SQL Table

Users OUSR 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