| Column | Field | Description | SQL Type | Length | Decimals | SAP Type | Default Value | Null Allowed | CheckTable | Rollname | SQL Create Statement |
|---|
| 1 | MANDT | Client | nvarchar | 3 | 0 | CLNT | (N'000') | No | * | MANDT | Allow NULL? |
| 2 | DB_KEY | NodeID | varbinary | 16 | 0 | RAW | | No | | /BOBF/CONF_KEY | |
| 3 | NODE_CAT_KEY | NodeID | varbinary | 16 | 0 | RAW | | Yes | | /BOBF/CONF_KEY | |
| 4 | CUSTOMER_ID | Customer ID | nvarchar | 30 | 0 | CHAR | (N' ') | Yes | | /BOFU/DEMO_CUSTOMER_ID | Allow NULL? |
| 5 | SALES_ORG | Sales Organization | nvarchar | 10 | 0 | CHAR | (N' ') | Yes | | /BOFU/DEMO_SALES_ORG | Allow NULL? |
| 6 | CUST_CURR | Currency | nvarchar | 5 | 0 | CUKY | (N' ') | Yes | TCURC | /BOFU/DEMO_CURRENCY | Allow NULL? |
| 7 | LIFECYCLE_STATUS | Lifecycle Status Code | nvarchar | 2 | 0 | CHAR | (N' ') | Yes | | /BOFU/DEMO_LIFECYCLE_STATUS_CD | Allow NULL? |
| 8 | ARCHIVING_STATUS | Archiving Status | nvarchar | 2 | 0 | CHAR | (N' ') | Yes | | /BOFU/ARCHIVING_STATUS_CODE | Allow NULL? |
| 9 | CONSISTENCY_STS | Consistency Status (2 states) | nvarchar | 2 | 0 | CHAR | (N' ') | Yes | | /BOFU/CONSISTENCY_STATUS_2 | Allow NULL? |
| 10 | CREATED_BY | Created By | nvarchar | 12 | 0 | CHAR | (N' ') | Yes | * | /BOFU/USER_ID_CREATED_BY | Allow NULL? |
| 11 | CREATED_ON | Created on | decimal | 15 | 0 | DEC | ((0)) | Yes | | /BOFU/TSTMP_CREATION_TIME | |
| 12 | CHANGED_BY | Changed By | nvarchar | 12 | 0 | CHAR | (N' ') | Yes | * | /BOFU/USER_ID_CHANGED_BY | Allow NULL? |
| 13 | CHANGED_ON | Changed On | decimal | 15 | 0 | DEC | ((0)) | Yes | | /BOFU/TSTMP_CHANGED_TIME | |
| 14 | DISTANCE | Distance to Customer | decimal | 31 | 6 | QUAN | ((0)) | Yes | | /BOFU/DEMO_CUST_DISTANCE | |
| 15 | DIST_UOM | Unit of Measure | nvarchar | 3 | 0 | UNIT | (N' ') | Yes | T006 | /BOFU/DEMO_UOM | Allow NULL? |
| 16 | ALT_ID | Alternate ID (string field - to test change documents) | ntext | 1073741823 | 0 | | | Yes | | /BOFU/DEMO_CUST_ALT_ID | |
| 17 | TXC_KEY | NodeID | varbinary | 16 | 0 | RAW | | Yes | | /BOFU/CONF_KEY | |
| 18 | ATF_KEY | NodeID | varbinary | 16 | 0 | RAW | | Yes | | /BOFU/CONF_KEY | |
| 19 | ADDRESS_ID | Unique Identifier for Address (APC_V_ADDRESS_ID) | nvarchar | 40 | 0 | CHAR | (N' ') | Yes | | /BOFU/ADDRESS_ID | Allow NULL? |
| 20 | DUMMY | Dummy function in length 1 | char | 1 | 0 | CHAR | (N' ') | Yes | | DUMMY | Allow NULL? |
| 21 | ARCHIVEOFS | Archive file data object offset | int | 10 | 0 | INT4 | ((0)) | Yes | | ADMI_OFFST | Allow NULL? |
| 22 | ARCHIVEKEY | Key for Archive File | nvarchar | 20 | 0 | CHAR | (N' ') | Yes | | ARKEY | Allow NULL? |
| 23 | ZONE | Transportation zone to or from which the goods are delivered | nvarchar | 10 | 0 | CHAR | (N' ') | Yes | * | LZONE | Allow NULL? |
| 24 | ZONE1 | Transportation zone to or from which the goods are delivered | nvarchar | 10 | 0 | CHAR | (N' ') | Yes | * | LZONE | Allow NULL? |
| 25 | FROM_DATE | | nvarchar | 8 | 0 | | (N'00000000') | Yes | | | Allow NULL? |
| 26 | CUR2 | | nvarchar | 5 | 0 | | (N' ') | Yes | | | Allow NULL? |
