| Field |
Description |
Type |
Size |
Related |
Default Value |
Constraints |
| DocEntry |
Internal Document ID |
Int |
11 |
- |
|
|
|
| LineNum |
Row Number |
Int |
11 |
- |
|
|
|
| DocType |
Document Type |
Int |
11 |
- |
|
0 |
Item |
| |
|
|
|
|
|
1 |
Service |
| |
|
|
|
|
|
2 |
Item & Service |
| BusArea |
Business Area |
Int |
11 |
- |
|
0 |
Sales |
| |
|
|
|
|
|
1 |
Purchase |
| |
|
|
|
|
|
2 |
Sales & Purchase |
| Cond1 |
Condition 1 |
Int |
11 |
- |
|
0 |
|
| |
|
|
|
|
|
1 |
Federal Tax ID |
| |
|
|
|
|
|
2 |
Ship-To Address |
| |
|
|
|
|
|
3 |
Ship-To Street / PO Box |
| |
|
|
|
|
|
4 |
Ship-To City |
| |
|
|
|
|
|
5 |
Ship-To ZIP Code |
| |
|
|
|
|
|
6 |
Ship-To County |
| |
|
|
|
|
|
7 |
Ship-To State |
| |
|
|
|
|
|
8 |
Ship-to Country/Region |
| |
|
|
|
|
|
9 |
Item |
| |
|
|
|
|
|
10 |
Item Group |
| |
|
|
|
|
|
11 |
Business Partner |
| |
|
|
|
|
|
12 |
Customer Group |
| |
|
|
|
|
|
13 |
Vendor Group |
| |
|
|
|
|
|
14 |
Warehouse |
| |
|
|
|
|
|
15 |
G/L Account |
| |
|
|
|
|
|
16 |
Customer Equalization tax |
| |
|
|
|
|
|
17 |
Tax Status |
| |
|
|
|
|
|
18 |
Freight |
| |
|
|
|
|
|
19 |
UDF |
| |
|
|
|
|
|
20 |
Branch |
| |
|
|
|
|
|
21 |
Type of Business |
| UDFTable1 |
UDF Table Name |
nVarChar |
20 |
- |
|
|
|
| NumVal1 |
Numeric Value |
Int |
11 |
- |
|
|
|
| StrVal1 |
String Value |
nVarChar |
100 |
- |
|
|
|
| MnyVal1 |
Monetary Value |
Num |
19.6 |
- |
|
|
|
| Cond2 |
Condition 2 |
Int |
11 |
- |
|
0 |
|
| |
|
|
|
|
|
1 |
Federal Tax ID |
| |
|
|
|
|
|
2 |
Ship-To Address |
| |
|
|
|
|
|
3 |
Ship-To Street / PO Box |
| |
|
|
|
|
|
4 |
Ship-To City |
| |
|
|
|
|
|
5 |
Ship-To ZIP Code |
| |
|
|
|
|
|
6 |
Ship-To County |
| |
|
|
|
|
|
7 |
Ship-To State |
| |
|
|
|
|
|
8 |
Ship-to Country/Region |
| |
|
|
|
|
|
9 |
Item |
| |
|
|
|
|
|
10 |
Item Group |
| |
|
|
|
|
|
11 |
Business Partner |
| |
|
|
|
|
|
12 |
Customer Group |
| |
|
|
|
|
|
13 |
Vendor Group |
| |
|
|
|
|
|
14 |
Warehouse |
| |
|
|
|
|
|
15 |
G/L Account |
| |
|
|
|
|
|
16 |
Customer Equalization tax |
| |
|
|
|
|
|
17 |
Tax Status |
| |
|
|
|
|
|
18 |
Freight |
| |
|
|
|
|
|
19 |
UDF |
| |
|
|
|
|
|
20 |
Branch |
| |
|
|
|
|
|
21 |
Type of Business |
| UDFTable2 |
UDF Table Name |
nVarChar |
20 |
- |
|
|
|
| NumVal2 |
Numeric Value |
Int |
11 |
- |
|
|
|
| StrVal2 |
String Value |
nVarChar |
100 |
- |
|
|
|
| MnyVal2 |
Monetary Value |
Num |
19.6 |
- |
|
|
|
| Cond3 |
Condition 3 |
Int |
11 |
- |
|
0 |
|
| |
|
|
|
|
|
1 |
Federal Tax ID |
| |
|
|
|
|
|
2 |
Ship-To Address |
| |
|
|
|
|
|
3 |
Ship-To Street / PO Box |
| |
|
|
|
|
|
4 |
Ship-To City |
| |
|
|
|
|
|
5 |
Ship-To ZIP Code |
| |
|
|
|
|
|
6 |
Ship-To County |
| |
|
|
|
|
|
7 |
Ship-To State |
| |
|
|
|
|
|
8 |
Ship-to Country/Region |
| |
|
|
|
|
|
9 |
Item |
| |
|
|
|
|
|
10 |
Item Group |
| |
|
|
|
|
|
11 |
Business Partner |
| |
|
|
|
|
|
12 |
Customer Group |
| |
|
|
|
|
|
13 |
Vendor Group |
| |
|
|
|
|
|
14 |
Warehouse |
| |
|
|
|
|
|
15 |
G/L Account |
| |
|
|
|
|
|
16 |
Customer Equalization tax |
| |
|
|
|
|
|
17 |
Tax Status |
| |
|
|
|
|
|
18 |
Freight |
| |
|
|
|
|
|
19 |
UDF |
| |
|
|
|
|
|
20 |
Branch |
| |
|
|
|
|
|
21 |
Type of Business |
| UdfTable3 |
UDF Table Name |
nVarChar |
20 |
- |
|
|
|
| NumVal3 |
Numeric Value |
Int |
11 |
- |
|
|
|
| StrVal3 |
String Value |
nVarChar |
100 |
- |
|
|
|
| MnyVal3 |
Monetary Value |
Num |
19.6 |
- |
|
|
|
| Cond4 |
Condition 4 |
Int |
11 |
- |
|
0 |
|
| |
|
|
|
|
|
1 |
Federal Tax ID |
| |
|
|
|
|
|
2 |
Ship-To Address |
| |
|
|
|
|
|
3 |
Ship-To Street / PO Box |
| |
|
|
|
|
|
4 |
Ship-To City |
| |
|
|
|
|
|
5 |
Ship-To ZIP Code |
| |
|
|
|
|
|
6 |
Ship-To County |
| |
|
|
|
|
|
7 |
Ship-To State |
| |
|
|
|
|
|
8 |
Ship-to Country/Region |
| |
|
|
|
|
|
9 |
Item |
| |
|
|
|
|
|
10 |
Item Group |
| |
|
|
|
|
|
11 |
Business Partner |
| |
|
|
|
|
|
12 |
Customer Group |
| |
|
|
|
|
|
13 |
Vendor Group |
| |
|
|
|
|
|
14 |
Warehouse |
| |
|
|
|
|
|
15 |
G/L Account |
| |
|
|
|
|
|
16 |
Customer Equalization tax |
| |
|
|
|
|
|
17 |
Tax Status |
| |
|
|
|
|
|
18 |
Freight |
| |
|
|
|
|
|
19 |
UDF |
| |
|
|
|
|
|
20 |
Branch |
| |
|
|
|
|
|
21 |
Type of Business |
| UdfTable4 |
UDF Table Name |
nVarChar |
20 |
- |
|
|
|
| NumVal4 |
Numeric Value |
Int |
11 |
- |
|
|
|
| StrVal4 |
String Value |
nVarChar |
100 |
- |
|
|
|
| MnyVal4 |
Monetary Value |
Num |
19.6 |
- |
|
|
|
| Cond5 |
Condition 5 |
Int |
11 |
- |
|
0 |
|
| |
|
|
|
|
|
1 |
Federal Tax ID |
| |
|
|
|
|
|
2 |
Ship-To Address |
| |
|
|
|
|
|
3 |
Ship-To Street / PO Box |
| |
|
|
|
|
|
4 |
Ship-To City |
| |
|
|
|
|
|
5 |
Ship-To ZIP Code |
| |
|
|
|
|
|
6 |
Ship-To County |
| |
|
|
|
|
|
7 |
Ship-To State |
| |
|
|
|
|
|
8 |
Ship-to Country/Region |
| |
|
|
|
|
|
9 |
Item |
| |
|
|
|
|
|
10 |
Item Group |
| |
|
|
|
|
|
11 |
Business Partner |
| |
|
|
|
|
|
12 |
Customer Group |
| |
|
|
|
|
|
13 |
Vendor Group |
| |
|
|
|
|
|
14 |
Warehouse |
| |
|
|
|
|
|
15 |
G/L Account |
| |
|
|
|
|
|
16 |
Customer Equalization tax |
| |
|
|
|
|
|
17 |
Tax Status |
| |
|
|
|
|
|
18 |
Freight |
| |
|
|
|
|
|
19 |
UDF |
| |
|
|
|
|
|
20 |
Branch |
| |
|
|
|
|
|
21 |
Type of Business |
| UdfTable5 |
UDF Table Name |
nVarChar |
20 |
- |
|
|
|
| NumVal5 |
Numeric Value |
Int |
11 |
- |
|
|
|
| StrVal5 |
String Value |
nVarChar |
100 |
- |
|
|
|
| MnyVal5 |
Monetary Value |
Num |
19.6 |
- |
|
|
|
| Descr |
Description |
nVarChar |
250 |
- |
|
|
|
| LnTaxCode |
Line Tax Code |
nVarChar |
8 |
- |
|
|
|
| FrLnTax |
Line Freight Tax |
nVarChar |
8 |
- |
|
|
|
| FrHdrTax |
Header Freight Tax |
nVarChar |
8 |
- |
|
|
|
| UDFAlias1 |
UDF Field Alias |
nVarChar |
18 |
- |
|
|
|
| UDFAlias2 |
UDF Field Alias |
nVarChar |
18 |
- |
|
|
|
| UDFAlias3 |
UDF Field Alias |
nVarChar |
18 |
- |
|
|
|
| UDFAlias4 |
UDF Field Alias |
nVarChar |
18 |
- |
|
|
|
| UDFAlias5 |
UDF Field Alias |
nVarChar |
18 |
- |
|
|
|
| LogInstanc |
Log Instance |
Int |
11 |
- |
|
|
|
| UpdateDate |
Update Date |
Date |
8 |
- |
|
|
|
| UserSign |
User Signature |
Int |
6 |
OUSR |
|
|
|
| UserSign2 |
Update User |
Int |
6 |
OUSR |
|
|
|