| Column | Field | Description | Data Type | Edit Type | Length | Decimals | SQL Create Statement |
---|
| 1 | ABAST | Price Adjustment Name | String | UDC (40 TY) | 8 | 0 | Allow NULL? |
| 2 | ABAGTY | AgreementType | String | UDC (45 AT) | 2 | 0 | Allow NULL? |
| 3 | ABANS8 | Address Number | Numeric | Generic Edit | 8 | 0 | Allow NULL? |
| 4 | ABMCU | Business Unit | String | Generic Edit | 12 | 0 | Allow NULL? |
| 5 | ABAN8 | Address Number | Numeric | Generic Edit | 8 | 0 | Allow NULL? |
| 6 | ABITM | Item Number - Short | Numeric | Generic Edit | 8 | 0 | Allow NULL? |
| 7 | ABIGID | Item Group Key ID | Numeric | Generic Edit | 8 | 0 | Allow NULL? |
| 8 | ABCGID | Customer Group Key ID | Numeric | Generic Edit | 8 | 0 | Allow NULL? |
| 9 | ABASAI | Active/Inactive | Character | Generic Edit | 1 | 0 | Allow NULL? |
| 10 | ABEFTJ | Date - Effective | Date | Generic Edit | 6 | 0 | |
| 11 | ABEXDJ | Date - Expired | Date | Generic Edit | 6 | 0 | |
| 12 | ABAGSP | Agreement Number | String | Generic Edit | 8 | 0 | Allow NULL? |
| 13 | ABAGIN | Agreement Number - Internal | Numeric | Generic Edit | 8 | 0 | Allow NULL? |
| 14 | ABCATN | Catalog | String | UDC (40 CN) | 8 | 0 | Allow NULL? |
| 15 | ABRPER | Person Responsible | Numeric | Generic Edit | 8 | 0 | Allow NULL? |
| 16 | ABSCLM | Address Number - Send Claim To | Numeric | Generic Edit | 8 | 0 | Allow NULL? |
| 17 | ABCLMD | Claim Method | Character | UDC (45 CM) | 1 | 0 | Allow NULL? |
| 18 | ABCCF3 | Currency Code - From 3 | String | Generic Edit | 3 | 0 | Allow NULL? |
| 19 | ABBDCS | Amount - Based On Cost | Numeric | Generic Edit | 15 | 4 | Allow NULL? |
| 20 | ABBDCL | Based On Cost Lock Flag | Character | Generic Edit | 1 | 0 | Allow NULL? |
| 21 | ABFRMN | Price Formula Name | String | UDC (40 FM) | 10 | 0 | Allow NULL? |
| 22 | ABFVMD | Factor Value Method | Character | UDC (40 BC) | 1 | 0 | Allow NULL? |
| 23 | ABPUFR | Per Unit Factor | Character | Generic Edit | 1 | 0 | Allow NULL? |
| 24 | ABMQYQ | Units - Minimum Quantity to Qualify | Numeric | Generic Edit | 15 | 0 | Allow NULL? |
| 25 | ABMAQY | Units - Maximum Authorized Quantity | Numeric | Generic Edit | 15 | 0 | Allow NULL? |
| 26 | ABQYOA | Units - Quantity Open/Available | Numeric | Generic Edit | 15 | 0 | Allow NULL? |
| 27 | ABQYAP | Units - Quantity Applied | Numeric | Generic Edit | 15 | 0 | Allow NULL? |
| 28 | ABQYCL | Units - Claimed Quantity | Numeric | Generic Edit | 15 | 0 | Allow NULL? |
| 29 | ABUOM | Unit of Measure as Input | String | UDC (00 UM) | 2 | 0 | Allow NULL? |
| 30 | ABBC01 | Ship And Debit Cost Indicator | String | Generic Edit | 3 | 0 | Allow NULL? |
| 31 | ABBC02 | Adjustment Balances 02 | String | Generic Edit | 3 | 0 | Allow NULL? |
| 32 | ABBC03 | Adjustment Balances 03 | String | Generic Edit | 3 | 0 | Allow NULL? |
| 33 | ABBC04 | Adjustment Balances 04 | String | Generic Edit | 3 | 0 | Allow NULL? |
| 34 | ABBC05 | Adjustment Balances 05 | String | Generic Edit | 3 | 0 | Allow NULL? |
| 35 | ABURCD | User Reserved Code | String | Generic Edit | 2 | 0 | Allow NULL? |
| 36 | ABURDT | User Reserved Date | Date | Generic Edit | 6 | 0 | |
| 37 | ABURAT | User Reserved Amount | Numeric | Generic Edit | 15 | 2 | Allow NULL? |
| 38 | ABURAB | User Reserved Number | Numeric | Generic Edit | 8 | 0 | Allow NULL? |
| 39 | ABURRF | User Reserved Reference | String | Generic Edit | 15 | 0 | Allow NULL? |
| 40 | ABUSER | User ID | String | Generic Edit | 10 | 0 | Allow NULL? |
| 41 | ABPID | Program ID | String | Generic Edit | 10 | 0 | Allow NULL? |
| 42 | ABJOBN | Work Station ID | String | Generic Edit | 10 | 0 | Allow NULL? |
| 43 | ABUPMJ | Date - Updated | Date | Generic Edit | 6 | 0 | |
| 44 | ABTDAY | Time of Day | Numeric | Generic Edit | 6 | 0 | Allow NULL? |
| 45 | ABAGNB | Agreement Number - Supplier | String | Generic Edit | 30 | 0 | Allow NULL? |