|
Name |
Description |
Length |
Input |
Data Type |
| ASSEMBLY_LEVEL |
Assembly Level |
2 |
Optional |
Small Integer |
| AVERAGE_COST_PRICE |
Average Cost Price |
8 |
Optional |
Double |
| BUDGET_QTY_SOLD_BF |
Brought Forward Budget Quantity Sold |
8 |
Optional |
Double |
| BUDGET_QTY_SOLD_FUTURE |
Future Budget Quantity Sold |
8 |
Optional |
Double |
| BUDGET_QTY_SOLD_MTH1 |
Month 1 Budget Quantity Sold |
8 |
Optional |
Double |
| BUDGET_QTY_SOLD_MTH10 |
Month 10 Budget Quantity Sold |
8 |
Optional |
Double |
| BUDGET_QTY_SOLD_MTH11 |
Month 11 Budget Quantity Sold |
8 |
Optional |
Double |
| BUDGET_QTY_SOLD_MTH12 |
Month 12 Budget Quantity Sold |
8 |
Optional |
Double |
| BUDGET_QTY_SOLD_MTH2 |
Month 2 Budget Quantity Sold |
8 |
Optional |
Double |
| BUDGET_QTY_SOLD_MTH3 |
Month 3 Budget Quantity Sold |
8 |
Optional |
Double |
| BUDGET_QTY_SOLD_MTH4 |
Month 4 Budget Quantity Sold |
8 |
Optional |
Double |
| BUDGET_QTY_SOLD_MTH5 |
Month 5 Budget Quantity Sold |
8 |
Optional |
Double |
| BUDGET_QTY_SOLD_MTH6 |
Month 6 Budget Quantity Sold |
8 |
Optional |
Double |
| BUDGET_QTY_SOLD_MTH7 |
Month 7 Budget Quantity Sold |
8 |
Optional |
Double |
| BUDGET_QTY_SOLD_MTH8 |
Month 8 Budget Quantity Sold |
8 |
Optional |
Double |
| BUDGET_QTY_SOLD_MTH9 |
Month 9 Budget Quantity Sold |
8 |
Optional |
Double |
| BUDGET_SALES_BF |
Brought Forward Budget Sales |
8 |
Optional |
Double |
| BUDGET_SALES_FUTURE |
Future Budget Sales |
8 |
Optional |
Double |
| BUDGET_SALES_MTH1 |
Month 1 Budget Sales |
8 |
Optional |
Double |
| BUDGET_SALES_MTH10 |
Month 10 Budget Sales |
8 |
Optional |
Double |
| BUDGET_SALES_MTH11 |
Month 11 Budget Sales |
8 |
Optional |
Double |
| BUDGET_SALES_MTH12 |
Month 12 Budget Sales |
8 |
Optional |
Double |
| BUDGET_SALES_MTH2 |
Month 2 Budget Sales |
8 |
Optional |
Double |
| BUDGET_SALES_MTH3 |
Month 3 Budget Sales |
8 |
Optional |
Double |
| BUDGET_SALES_MTH4 |
Month 4 Budget Sales |
8 |
Optional |
Double |
| BUDGET_SALES_MTH5 |
Month 5 Budget Sales |
8 |
Optional |
Double |
| BUDGET_SALES_MTH6 |
Month 6 Budget Sales |
8 |
Optional |
Double |
| BUDGET_SALES_MTH7 |
Month 7 Budget Sales |
8 |
Optional |
Double |
| BUDGET_SALES_MTH8 |
Month 8 Budget Sales |
8 |
Optional |
Double |
| BUDGET_SALES_MTH9 |
Month 9 Budget Sales |
8 |
Optional |
Double |
| COMMODITY_CODE |
Commodity Code |
30 |
Optional |
String |
| COMPONENT_CODE_1 |
Component 1 Stock Code |
30 |
Optional |
String |
| COMPONENT_CODE_10 |
Component 10 Stock Code |
30 |
Optional |
String |
| COMPONENT_CODE_2 |
Component 2 Stock Code |
30 |
Optional |
String |
| COMPONENT_CODE_3 |
Component 3 Stock Code |
30 |
Optional |
String |
| COMPONENT_CODE_4 |
Component 4 Stock Code |
30 |
Optional |
String |
| COMPONENT_CODE_5 |
Component 5 Stock Code |
30 |
Optional |
String |
| COMPONENT_CODE_6 |
Component 6 Stock Code |
30 |
Optional |
String |
| COMPONENT_CODE_7 |
Component 7 Stock Code |
30 |
Optional |
String |
| COMPONENT_CODE_8 |
Component 8 Stock Code |
30 |
Optional |
String |
| COMPONENT_CODE_9 |
Component 9 Stock Code |
30 |
Optional |
String |
| COMPONENT_QTY_1 |
Component 1 Quantity |
8 |
Optional |
Double |
| COMPONENT_QTY_10 |
Component 10 Quantity |
8 |
Optional |
Double |
| COMPONENT_QTY_2 |
Component 2 Quantity |
8 |
Optional |
Double |
| COMPONENT_QTY_3 |
Component 3 Quantity |
8 |
Optional |
Double |
| COMPONENT_QTY_4 |
Component 4 Quantity |
8 |
Optional |
Double |
| COMPONENT_QTY_5 |
Component 5 Quantity |
8 |
Optional |
Double |
| COMPONENT_QTY_6 |
Component 6 Quantity |
8 |
Optional |
Double |
| COMPONENT_QTY_7 |
Component 7 Quantity |
8 |
Optional |
Double |
| COMPONENT_QTY_8 |
Component 8 Quantity |
8 |
Optional |
Double |
| COMPONENT_QTY_9 |
Component 9 Quantity |
8 |
Optional |
Double |
| COST_BF |
Brought Forward Costs |
8 |
Optional |
Double |
| COST_FUTURE |
Future Costs |
8 |
Optional |
Double |
| COST_MTH1 |
Month 1 Costs |
8 |
Optional |
Double |
| COST_MTH10 |
Month 10 Costs |
8 |
Optional |
Double |
| COST_MTH11 |
Month 11 Costs |
8 |
Optional |
Double |
| COST_MTH12 |
Month 12 Costs |
8 |
Optional |
Double |
| COST_MTH2 |
Month 2 Costs |
8 |
Optional |
Double |
| COST_MTH3 |
Month 3 Costs |
8 |
Optional |
Double |
| COST_MTH4 |
Month 4 Costs |
8 |
Optional |
Double |
| COST_MTH5 |
Month 5 Costs |
8 |
Optional |
Double |
| COST_MTH6 |
Month 6 Costs |
8 |
Optional |
Double |
| COST_MTH7 |
Month 7 Costs |
8 |
Optional |
Double |
| COST_MTH8 |
Month 8 Costs |
8 |
Optional |
Double |
| COST_MTH9 |
Month 9 Costs |
8 |
Optional |
Double |
| DELETED_FLAG |
Deleted? |
2 |
Optional |
Small Integer |
| DEPT_NUMBER |
Department Number |
2 |
Optional |
Small Integer |
| DESCRIPTION |
Description |
60 |
Optional |
String |
| DISC_A_LEVEL_10_QTY |
Discount Table A, Break Level 10, Quantity |
8 |
Optional |
Double |
| DISC_A_LEVEL_10_RATE |
Discount Table A, Break Level 10, Rate |
8 |
Optional |
Double |
| DISC_A_LEVEL_1_QTY |
Discount Table A, Break Level 1, Quantity |
8 |
Optional |
Double |
| DISC_A_LEVEL_1_RATE |
Discount Table A, Break Level 1, Rate |
8 |
Optional |
Double |
| DISC_A_LEVEL_2_QTY |
Discount Table A, Break Level 2, Quantity |
8 |
Optional |
Double |
| DISC_A_LEVEL_2_RATE |
Discount Table A, Break Level 2, Rate |
8 |
Optional |
Double |
| DISC_A_LEVEL_3_QTY |
Discount Table A, Break Level 3, Quantity |
8 |
Optional |
Double |
| DISC_A_LEVEL_3_RATE |
Discount Table A, Break Level 3, Rate |
8 |
Optional |
Double |
| DISC_A_LEVEL_4_QTY |
Discount Table A, Break Level 4, Quantity |
8 |
Optional |
Double |
| DISC_A_LEVEL_4_RATE |
Discount Table A, Break Level 4, Rate |
8 |
Optional |
Double |
| DISC_A_LEVEL_5_QTY |
Discount Table A, Break Level 5, Quantity |
8 |
Optional |
Double |
| DISC_A_LEVEL_5_RATE |
Discount Table A, Break Level 5, Rate |
8 |
Optional |
Double |
| DISC_A_LEVEL_6_QTY |
Discount Table A, Break Level 6, Quantity |
8 |
Optional |
Double |
| DISC_A_LEVEL_6_RATE |
Discount Table A, Break Level 6, Rate |
8 |
Optional |
Double |
| DISC_A_LEVEL_7_QTY |
Discount Table A, Break Level 7, Quantity |
8 |
Optional |
Double |
| DISC_A_LEVEL_7_RATE |
Discount Table A, Break Level 7, Rate |
8 |
Optional |
Double |
| DISC_A_LEVEL_8_QTY |
Discount Table A, Break Level 8, Quantity |
8 |
Optional |
Double |
| DISC_A_LEVEL_8_RATE |
Discount Table A, Break Level 8, Rate |
8 |
Optional |
Double |
| DISC_A_LEVEL_9_QTY |
Discount Table A, Break Level 9, Quantity |
8 |
Optional |
Double |
| DISC_A_LEVEL_9_RATE |
Discount Table A, Break Level 9, Rate |
8 |
Optional |
Double |
| DISC_B_LEVEL_10_QTY |
Discount Table B, Break Level 10, Quantity |
8 |
Optional |
Double |
| DISC_B_LEVEL_10_RATE |
Discount Table B, Break Level 10, Rate |
8 |
Optional |
Double |
| DISC_B_LEVEL_1_QTY |
Discount Table B, Break Level 1, Quantity |
8 |
Optional |
Double |
| DISC_B_LEVEL_1_RATE |
Discount Table B, Break Level 1, Rate |
8 |
Optional |
Double |
| DISC_B_LEVEL_2_QTY |
Discount Table B, Break Level 2, Quantity |
8 |
Optional |
Double |
| DISC_B_LEVEL_2_RATE |
Discount Table B, Break Level 2, Rate |
8 |
Optional |
Double |
| DISC_B_LEVEL_3_QTY |
Discount Table B, Break Level 3, Quantity |
8 |
Optional |
Double |
| DISC_B_LEVEL_3_RATE |
Discount Table B, Break Level 3, Rate |
8 |
Optional |
Double |
| DISC_B_LEVEL_4_QTY |
Discount Table B, Break Level 4, Quantity |
8 |
Optional |
Double |
| DISC_B_LEVEL_4_RATE |
Discount Table B, Break Level 4, Rate |
8 |
Optional |
Double |
| DISC_B_LEVEL_5_QTY |
Discount Table B, Break Level 5, Quantity |
8 |
Optional |
Double |
| DISC_B_LEVEL_5_RATE |
Discount Table B, Break Level 5, Rate |
8 |
Optional |
Double |
| DISC_B_LEVEL_6_QTY |
Discount Table B, Break Level 6, Quantity |
8 |
Optional |
Double |
| DISC_B_LEVEL_6_RATE |
Discount Table B, Break Level 6, Rate |
8 |
Optional |
Double |
| DISC_B_LEVEL_7_QTY |
Discount Table B, Break Level 7, Quantity |
8 |
Optional |
Double |
| DISC_B_LEVEL_7_RATE |
Discount Table B, Break Level 7, Rate |
8 |
Optional |
Double |
| DISC_B_LEVEL_8_QTY |
Discount Table B, Break Level 8, Quantity |
8 |
Optional |
Double |
| DISC_B_LEVEL_8_RATE |
Discount Table B, Break Level 8, Rate |
8 |
Optional |
Double |
| DISC_B_LEVEL_9_QTY |
Discount Table B, Break Level 9, Quantity |
8 |
Optional |
Double |
| DISC_B_LEVEL_9_RATE |
Discount Table B, Break Level 9, Rate |
8 |
Optional |
Double |
| DISC_C_LEVEL_10_QTY |
Discount Table C, Break Level 10, Quantity |
8 |
Optional |
Double |
| DISC_C_LEVEL_10_RATE |
Discount Table C, Break Level 10, Rate |
8 |
Optional |
Double |
| DISC_C_LEVEL_1_QTY |
Discount Table C, Break Level 1, Quantity |
8 |
Optional |
Double |
| DISC_C_LEVEL_1_RATE |
Discount Table C, Break Level 1, Rate |
8 |
Optional |
Double |
| DISC_C_LEVEL_2_QTY |
Discount Table C, Break Level 2, Quantity |
8 |
Optional |
Double |
| DISC_C_LEVEL_2_RATE |
Discount Table C, Break Level 2, Rate |
8 |
Optional |
Double |
| DISC_C_LEVEL_3_QTY |
Discount Table C, Break Level 3, Quantity |
8 |
Optional |
Double |
| DISC_C_LEVEL_3_RATE |
Discount Table C, Break Level 3, Rate |
8 |
Optional |
Double |
| DISC_C_LEVEL_4_QTY |
Discount Table C, Break Level 4, Quantity |
8 |
Optional |
Double |
| DISC_C_LEVEL_4_RATE |
Discount Table C, Break Level 4, Rate |
8 |
Optional |
Double |
| DISC_C_LEVEL_5_QTY |
Discount Table C, Break Level 5, Quantity |
8 |
Optional |
Double |
| DISC_C_LEVEL_5_RATE |
Discount Table C, Break Level 5, Rate |
8 |
Optional |
Double |
| DISC_C_LEVEL_6_QTY |
Discount Table C, Break Level 6, Quantity |
8 |
Optional |
Double |
| DISC_C_LEVEL_6_RATE |
Discount Table C, Break Level 6, Rate |
8 |
Optional |
Double |
| DISC_C_LEVEL_7_QTY |
Discount Table C, Break Level 7, Quantity |
8 |
Optional |
Double |
| DISC_C_LEVEL_7_RATE |
Discount Table C, Break Level 7, Rate |
8 |
Optional |
Double |
| DISC_C_LEVEL_8_QTY |
Discount Table C, Break Level 8, Quantity |
8 |
Optional |
Double |
| DISC_C_LEVEL_8_RATE |
Discount Table C, Break Level 8, Rate |
8 |
Optional |
Double |
| DISC_C_LEVEL_9_QTY |
Discount Table C, Break Level 9, Quantity |
8 |
Optional |
Double |
| DISC_C_LEVEL_9_RATE |
Discount Table C, Break Level 9, Rate |
8 |
Optional |
Double |
| DISC_D_LEVEL_10_QTY |
Discount Table D, Break Level 10, Quantity |
8 |
Optional |
Double |
| DISC_D_LEVEL_10_RATE |
Discount Table D, Break Level 10, Rate |
8 |
Optional |
Double |
| DISC_D_LEVEL_1_QTY |
Discount Table D, Break Level 1, Quantity |
8 |
Optional |
Double |
| DISC_D_LEVEL_1_RATE |
Discount Table D, Break Level 1, Rate |
8 |
Optional |
Double |
| DISC_D_LEVEL_2_QTY |
Discount Table D, Break Level 2, Quantity |
8 |
Optional |
Double |
| DISC_D_LEVEL_2_RATE |
Discount Table D, Break Level 2, Rate |
8 |
Optional |
Double |
| DISC_D_LEVEL_3_QTY |
Discount Table D, Break Level 3, Quantity |
8 |
Optional |
Double |
| DISC_D_LEVEL_3_RATE |
Discount Table D, Break Level 3, Rate |
8 |
Optional |
Double |
| DISC_D_LEVEL_4_QTY |
Discount Table D, Break Level 4, Quantity |
8 |
Optional |
Double |
| DISC_D_LEVEL_4_RATE |
Discount Table D, Break Level 4, Rate |
8 |
Optional |
Double |
| DISC_D_LEVEL_5_QTY |
Discount Table D, Break Level 5, Quantity |
8 |
Optional |
Double |
| DISC_D_LEVEL_5_RATE |
Discount Table D, Break Level 5, Rate |
8 |
Optional |
Double |
| DISC_D_LEVEL_6_QTY |
Discount Table D, Break Level 6, Quantity |
8 |
Optional |
Double |
| DISC_D_LEVEL_6_RATE |
Discount Table D, Break Level 6, Rate |
8 |
Optional |
Double |
| DISC_D_LEVEL_7_QTY |
Discount Table D, Break Level 7, Quantity |
8 |
Optional |
Double |
| DISC_D_LEVEL_7_RATE |
Discount Table D, Break Level 7, Rate |
8 |
Optional |
Double |
| DISC_D_LEVEL_8_QTY |
Discount Table D, Break Level 8, Quantity |
8 |
Optional |
Double |
| DISC_D_LEVEL_8_RATE |
Discount Table D, Break Level 8, Rate |
8 |
Optional |
Double |
| DISC_D_LEVEL_9_QTY |
Discount Table D, Break Level 9, Quantity |
8 |
Optional |
Double |
| DISC_D_LEVEL_9_RATE |
Discount Table D, Break Level 9, Rate |
8 |
Optional |
Double |
| DISC_E_LEVEL_10_QTY |
Discount Table E, Break Level 10, Quantity |
8 |
Optional |
Double |
| DISC_E_LEVEL_10_RATE |
Discount Table E, Break Level 10, Rate |
8 |
Optional |
Double |
| DISC_E_LEVEL_1_QTY |
Discount Table E, Break Level 1, Quantity |
8 |
Optional |
Double |
| DISC_E_LEVEL_1_RATE |
Discount Table E, Break Level 1, Rate |
8 |
Optional |
Double |
| DISC_E_LEVEL_2_QTY |
Discount Table E, Break Level 2, Quantity |
8 |
Optional |
Double |
| DISC_E_LEVEL_2_RATE |
Discount Table E, Break Level 2, Rate |
8 |
Optional |
Double |
| DISC_E_LEVEL_3_QTY |
Discount Table E, Break Level 3, Quantity |
8 |
Optional |
Double |
| DISC_E_LEVEL_3_RATE |
Discount Table E, Break Level 3, Rate |
8 |
Optional |
Double |
| DISC_E_LEVEL_4_QTY |
Discount Table E, Break Level 4, Quantity |
8 |
Optional |
Double |
| DISC_E_LEVEL_4_RATE |
Discount Table E, Break Level 4, Rate |
8 |
Optional |
Double |
| DISC_E_LEVEL_5_QTY |
Discount Table E, Break Level 5, Quantity |
8 |
Optional |
Double |
| DISC_E_LEVEL_5_RATE |
Discount Table E, Break Level 5, Rate |
8 |
Optional |
Double |
| DISC_E_LEVEL_6_QTY |
Discount Table E, Break Level 6, Quantity |
8 |
Optional |
Double |
| DISC_E_LEVEL_6_RATE |
Discount Table E, Break Level 6, Rate |
8 |
Optional |
Double |
| DISC_E_LEVEL_7_QTY |
Discount Table E, Break Level 7, Quantity |
8 |
Optional |
Double |
| DISC_E_LEVEL_7_RATE |
Discount Table E, Break Level 7, Rate |
8 |
Optional |
Double |
| DISC_E_LEVEL_8_QTY |
Discount Table E, Break Level 8, Quantity |
8 |
Optional |
Double |
| DISC_E_LEVEL_8_RATE |
Discount Table E, Break Level 8, Rate |
8 |
Optional |
Double |
| DISC_E_LEVEL_9_QTY |
Discount Table E, Break Level 9, Quantity |
8 |
Optional |
Double |
| DISC_E_LEVEL_9_RATE |
Discount Table E, Break Level 9, Rate |
8 |
Optional |
Double |
| EXTERNAL_USAGE |
Number of External Usages |
4 |
Optional |
Long Integer |
| FIRST_TRAN |
Record Number of First Transaction |
4 |
Optional |
Long Integer |
| IGNORE_STK_LVL_FLAG |
Ignore Stock Level Flag |
1 |
Optional |
Byte or Character |
| LAST_PURCHASE_DATE |
Last Purchase Date |
2 |
Optional |
Date |
| LAST_PURCHASE_PRICE |
Last Purchase Price |
8 |
Optional |
Double |
| LAST_SALE_DATE |
Last Sale Date |
2 |
Optional |
Date |
| LAST_TRAN |
Record Number of Last Transaction |
4 |
Optional |
Long Integer |
| LINK_LEVEL |
Link Level |
2 |
Optional |
Small Integer |
| LOCATION |
Bin Location |
16 |
Optional |
String |
| NO_OF_TRAN |
Number of Transactions |
4 |
Optional |
Long Integer |
| NOMINAL_CODE |
Nominal Code |
8 |
Optional |
String |
| PRIOR_YR_COST_BF |
Prior Year Brought Forward Costs |
8 |
Optional |
Double |
| PRIOR_YR_COST_FUTURE |
Prior Year Future Costs |
8 |
Optional |
Double |
| PRIOR_YR_COST_MTH1 |
Prior Year Month 1 Costs |
8 |
Optional |
Double |
| PRIOR_YR_COST_MTH10 |
Prior Year Month 10 Costs |
8 |
Optional |
Double |
| PRIOR_YR_COST_MTH11 |
Prior Year Month 11 Costs |
8 |
Optional |
Double |
| PRIOR_YR_COST_MTH12 |
Prior Year Month 12 Costs |
8 |
Optional |
Double |
| PRIOR_YR_COST_MTH2 |
Prior Year Month 2 Costs |
8 |
Optional |
Double |
| PRIOR_YR_COST_MTH3 |
Prior Year Month 3 Costs |
8 |
Optional |
Double |
| PRIOR_YR_COST_MTH4 |
Prior Year Month 4 Costs |
8 |
Optional |
Double |
| PRIOR_YR_COST_MTH5 |
Prior Year Month 5 Costs |
8 |
Optional |
Double |
| PRIOR_YR_COST_MTH6 |
Prior Year Month 6 Costs |
8 |
Optional |
Double |
| PRIOR_YR_COST_MTH7 |
Prior Year Month 7 Costs |
8 |
Optional |
Double |
| PRIOR_YR_COST_MTH8 |
Prior Year Month 8 Costs |
8 |
Optional |
Double |
| PRIOR_YR_COST_MTH9 |
Prior Year Month 9 Costs |
8 |
Optional |
Double |
| PRIOR_YR_QTY_SOLD_BF |
Prior Year Brought Forward Quantity Sold |
8 |
Optional |
Double |
| PRIOR_YR_QTY_SOLD_FUTURE |
Prior Year Future Quantity Sold |
8 |
Optional |
Double |
| PRIOR_YR_QTY_SOLD_MTH1 |
Prior Year Month 1 Quantity Sold |
8 |
Optional |
Double |
| PRIOR_YR_QTY_SOLD_MTH10 |
Prior Year Month 10 Quantity Sold |
8 |
Optional |
Double |
| PRIOR_YR_QTY_SOLD_MTH11 |
Prior Year Month 11 Quantity Sold |
8 |
Optional |
Double |
| PRIOR_YR_QTY_SOLD_MTH12 |
Prior Year Month 12 Quantity Sold |
8 |
Optional |
Double |
| PRIOR_YR_QTY_SOLD_MTH2 |
Prior Year Month 2 Quantity Sold |
8 |
Optional |
Double |
| PRIOR_YR_QTY_SOLD_MTH3 |
Prior Year Month 3 Quantity Sold |
8 |
Optional |
Double |
| PRIOR_YR_QTY_SOLD_MTH4 |
Prior Year Month 4 Quantity Sold |
8 |
Optional |
Double |
| PRIOR_YR_QTY_SOLD_MTH5 |
Prior Year Month 5 Quantity Sold |
8 |
Optional |
Double |
| PRIOR_YR_QTY_SOLD_MTH6 |
Prior Year Month 6 Quantity Sold |
8 |
Optional |
Double |
| PRIOR_YR_QTY_SOLD_MTH7 |
Prior Year Month 7 Quantity Sold |
8 |
Optional |
Double |
| PRIOR_YR_QTY_SOLD_MTH8 |
Prior Year Month 8 Quantity Sold |
8 |
Optional |
Double |
| PRIOR_YR_QTY_SOLD_MTH9 |
Prior Year Month 9 Quantity Sold |
8 |
Optional |
Double |
| PRIOR_YR_SALES_BF |
Prior Year Brought Forward Sales |
8 |
Optional |
Double |
| PRIOR_YR_SALES_FUTURE |
Prior Year Future Sales |
8 |
Optional |
Double |
| PRIOR_YR_SALES_MTH1 |
Prior Year Month 1 Sales |
8 |
Optional |
Double |
| PRIOR_YR_SALES_MTH10 |
Prior Year Month 10 Sales |
8 |
Optional |
Double |
| PRIOR_YR_SALES_MTH11 |
Prior Year Month 11 Sales |
8 |
Optional |
Double |
| PRIOR_YR_SALES_MTH12 |
Prior Year Month 12 Sales |
8 |
Optional |
Double |
| PRIOR_YR_SALES_MTH2 |
Prior Year Month 2 Sales |
8 |
Optional |
Double |
| PRIOR_YR_SALES_MTH3 |
Prior Year Month 3 Sales |
8 |
Optional |
Double |
| PRIOR_YR_SALES_MTH4 |
Prior Year Month 4 Sales |
8 |
Optional |
Double |
| PRIOR_YR_SALES_MTH5 |
Prior Year Month 5 Sales |
8 |
Optional |
Double |
| PRIOR_YR_SALES_MTH6 |
Prior Year Month 6 Sales |
8 |
Optional |
Double |
| PRIOR_YR_SALES_MTH7 |
Prior Year Month 7 Sales |
8 |
Optional |
Double |
| PRIOR_YR_SALES_MTH8 |
Prior Year Month 8 Sales |
8 |
Optional |
Double |
| PRIOR_YR_SALES_MTH9 |
Prior Year Month 9 Sales |
8 |
Optional |
Double |
| PURCHASE_REF |
Supplier's Account Reference |
8 |
Optional |
String |
| QTY_ALLOCATED |
Quantity Allocated |
8 |
Optional |
Double |
| QTY_IN_STOCK |
Quantity in Stock |
8 |
Optional |
Double |
| QTY_LAST_ORDER |
Last Order Quantity |
8 |
Optional |
Double |
| QTY_LAST_STOCK_TAKE |
Last Stock Take Quantity |
8 |
Optional |
Double |
| QTY_ON_ORDER |
Quantity on Order |
8 |
Optional |
Double |
| QTY_REORDER |
Reorder Quantity |
8 |
Optional |
Double |
| QTY_REORDER_LEVEL |
Reorder Level |
8 |
Optional |
Double |
| QTY_SOLD_BF |
Brought Forward Quantity Sold |
8 |
Optional |
Double |
| QTY_SOLD_FUTURE |
Future Quantity Sold |
8 |
Optional |
Double |
| QTY_SOLD_MTH1 |
Month 1 Quantity Sold |
8 |
Optional |
Double |
| QTY_SOLD_MTH10 |
Month 10 Quantity Sold |
8 |
Optional |
Double |
| QTY_SOLD_MTH11 |
Month 11 Quantity Sold |
8 |
Optional |
Double |
| QTY_SOLD_MTH12 |
Month 12 Quantity Sold |
8 |
Optional |
Double |
| QTY_SOLD_MTH2 |
Month 2 Quantity Sold |
8 |
Optional |
Double |
| QTY_SOLD_MTH3 |
Month 3 Quantity Sold |
8 |
Optional |
Double |
| QTY_SOLD_MTH4 |
Month 4 Quantity Sold |
8 |
Optional |
Double |
| QTY_SOLD_MTH5 |
Month 5 Quantity Sold |
8 |
Optional |
Double |
| QTY_SOLD_MTH6 |
Month 6 Quantity Sold |
8 |
Optional |
Double |
| QTY_SOLD_MTH7 |
Month 7 Quantity Sold |
8 |
Optional |
Double |
| QTY_SOLD_MTH8 |
Month 8 Quantity Sold |
8 |
Optional |
Double |
| QTY_SOLD_MTH9 |
Month 9 Quantity Sold |
8 |
Optional |
Double |
| SALES_BF |
Brought Forward Sales |
8 |
Optional |
Double |
| SALES_FUTURE |
Future Sales |
8 |
Optional |
Double |
| SALES_MTH1 |
Month 1 Sales |
8 |
Optional |
Double |
| SALES_MTH10 |
Month 10 Sales |
8 |
Optional |
Double |
| SALES_MTH11 |
Month 11 Sales |
8 |
Optional |
Double |
| SALES_MTH12 |
Month 12 Sales |
8 |
Optional |
Double |
| SALES_MTH2 |
Month 2 Sales |
8 |
Optional |
Double |
| SALES_MTH3 |
Month 3 Sales |
8 |
Optional |
Double |
| SALES_MTH4 |
Month 4 Sales |
8 |
Optional |
Double |
| SALES_MTH5 |
Month 5 Sales |
8 |
Optional |
Double |
| SALES_MTH6 |
Month 6 Sales |
8 |
Optional |
Double |
| SALES_MTH7 |
Month 7 Sales |
8 |
Optional |
Double |
| SALES_MTH8 |
Month 8 Sales |
8 |
Optional |
Double |
| SALES_MTH9 |
Month 9 Sales |
8 |
Optional |
Double |
| SALES_PRICE |
Sale Price |
8 |
Optional |
Double |
| STOCK_CAT |
Stock Category Number |
2 |
Optional |
Small Integer |
| STOCK_CODE |
Stock Code |
30 |
Required |
String |
| STOCK_TAKE_DATE |
Stock Take Date |
2 |
Optional |
Date |
| SUPPLIER_PART_NUMBER |
Supplier's Part Number |
16 |
Optional |
String |
| TAX_CODE |
Tax Code |
2 |
Optional |
Small Integer |
| UNIT_OF_SALE |
Unit of Sale |
8 |
Optional |
String |
| UNIT_WEIGHT |
Unit Weight |
8 |
Optional |
Double |