| Field |
Description |
Type |
Size |
Related |
Default Value |
Constraints |
| GroupNum |
Group Number |
Int |
6 |
- |
|
|
|
| PymntGroup |
Payment Terms Code |
nVarChar |
100 |
- |
|
|
|
| PayDuMonth |
Start From |
VarChar |
1 |
- |
N |
E |
Month End |
| |
|
|
|
|
|
H |
Half Month |
| |
|
|
|
|
|
Y |
Month Start |
| |
|
|
|
|
|
N |
|
| ExtraMonth |
Number of Additional Months |
Int |
6 |
- |
0 |
|
|
| ExtraDays |
Number of Additional Days |
Int |
6 |
- |
0 |
|
|
| PaymntsNum |
Number of Payments |
Int |
6 |
- |
|
|
|
| CredLimit |
Max. Credit |
Num |
19.6 |
- |
|
|
|
| VolumDscnt |
Total Discount % |
Num |
19.6 |
- |
|
|
|
| LatePyChrg |
Interest % on Receivables |
Num |
19.6 |
- |
|
|
|
| ObligLimit |
Commitment Limit |
Num |
19.6 |
- |
|
|
|
| ListNum |
Price List |
Int |
6 |
OPLN |
|
|
|
| Payments |
Partial Payment |
VarChar |
1 |
- |
N |
Y |
Yes |
| |
|
|
|
|
|
N |
No |
| NumOfPmnts |
Number of Payments |
Int |
6 |
- |
1 |
|
|
| Payment1 |
First Partial Payment |
Num |
19.6 |
- |
|
|
|
| DataSource |
Data Source |
VarChar |
1 |
- |
N |
N |
Unknown |
| |
|
|
|
|
|
I |
Interface |
| |
|
|
|
|
|
U |
Update |
| |
|
|
|
|
|
M |
Import |
| |
|
|
|
|
|
O |
DI API |
| |
|
|
|
|
|
S |
Service Layer |
| |
|
|
|
|
|
W |
Web Client |
| |
|
|
|
|
|
A |
Doc. Generation Wizard |
| |
|
|
|
|
|
D |
Restore Wizard |
| |
|
|
|
|
|
P |
Partner Implementation |
| |
|
|
|
|
|
T |
Year Transfer |
| UserSign |
User Signature |
Int |
6 |
OUSR |
|
|
|
| OpenRcpt |
Open Incoming Payment |
VarChar |
1 |
- |
N |
N |
No |
| |
|
|
|
|
|
3 |
Cash |
| |
|
|
|
|
|
1 |
Checks |
| |
|
|
|
|
|
4 |
Credit |
| |
|
|
|
|
|
2 |
Bank Transfer |
| |
|
|
|
|
|
5 |
Bill of Exchange |
| DiscCode |
Discount Code |
nVarChar |
20 |
OCDC |
|
|
|
| DunningCod |
Dunning Code |
nVarChar |
20 |
ORIT |
|
|
|
| BslineDate |
Due Date Based on |
VarChar |
1 |
- |
T |
P |
Posting Date |
| |
|
|
|
|
|
S |
System Date |
| |
|
|
|
|
|
T |
Document Date |
| |
|
|
|
|
|
C |
Closing Date |
| InstNum |
No. of Installments |
Int |
6 |
- |
|
|
|
| TolDays |
No. of Tolerance Days |
Int |
6 |
- |
|
|
|
| VATFirst |
Apply Tax on 1st Installment |
VarChar |
1 |
- |
N |
Y |
Yes |
| |
|
|
|
|
|
N |
No |
| |
|
|
|
|
|
T |
Tax Only |
| CrdMthd |
Credit Method |
VarChar |
1 |
- |
L |
F |
First Installment |
| |
|
|
|
|
|
L |
Last Installment |
| |
|
|
|
|
|
E |
Equally |
| CshRelev |
Cash Relevant Transaction |
VarChar |
1 |
- |
N |
Y |
Yes |
| |
|
|
|
|
|
N |
No |
| UserSign2 |
Update User |
Int |
6 |
OUSR |
|
|
|
| UpdateDate |
Update Date |
Date |
8 |
- |
|
|
|
| LogInstanc |
Log Instance |
Int |
11 |
- |
0 |
|
|
| CreateDate |
Creation Date |
Date |
8 |
- |
|
|
|