63 lines
2.6 KiB
Plaintext
63 lines
2.6 KiB
Plaintext
compile insert QUOTE_EQUATES
|
|
/*----------------------------------------
|
|
Author : Table Create Insert Routine
|
|
Written : 16/11/2011
|
|
Description : Insert for Table QUOTE
|
|
----------------------------------------*/
|
|
|
|
|
|
Equ QUOTE_SEQ$ To 0
|
|
Equ QUOTE_CUST_NO$ To 1
|
|
Equ QUOTE_NAME_NO$ To 2
|
|
Equ QUOTE_FAX$ To 3
|
|
Equ QUOTE_IFAX$ To 4
|
|
Equ QUOTE_ENTRY_ID$ To 5
|
|
Equ QUOTE_ENTRY_DATE$ To 6
|
|
Equ QUOTE_PROD_SPEC_ID$ To 7
|
|
Equ QUOTE_REQ_QUOTE_NUM$ To 8
|
|
Equ QUOTE_TERMS$ To 9
|
|
Equ QUOTE_STATUS$ To 10
|
|
Equ QUOTE_EXP_DATE$ To 11
|
|
Equ QUOTE_DETAIL$ To 13
|
|
Equ QUOTE_SETUP_CHARGE$ To 14
|
|
Equ QUOTE_QUANTITY$ To 15
|
|
Equ QUOTE_PRICE$ To 16
|
|
Equ QUOTE_SIGNATURES$ To 17
|
|
Equ QUOTE_COMMENTS$ To 18
|
|
Equ QUOTE_SPEC_BILL_INST$ To 19
|
|
Equ QUOTE_SPEC_SHIP_INST$ To 20
|
|
Equ QUOTE_SRP_CHARGE$ To 21
|
|
Equ QUOTE_DELIV_DATE$ To 22
|
|
Equ QUOTE_FINAL_LAYER$ To 23
|
|
Equ QUOTE_INQUIRY_STATUS$ To 24
|
|
Equ QUOTE_SALES_COMMENTS$ To 25
|
|
Equ QUOTE_QUOTE_OLD_ID$ To 26
|
|
Equ QUOTE_PRIOR_QUOTE_ID$ To 27
|
|
Equ QUOTE_PREV_PROD_SPEC_IDS$ To 28
|
|
Equ QUOTE_QUOTE_TYPE$ To 29
|
|
Equ QUOTE_OTHER_FOB_POINT$ To 30
|
|
Equ QUOTE_EXP_DATE_WARN$ To 31
|
|
Equ QUOTE_PROC_STEP_ORG$ To 32
|
|
Equ QUOTE_PROC_STEP_PSN_ORG$ To 33
|
|
Equ QUOTE_PROC_STEP_DESC_ORG$ To 34
|
|
Equ QUOTE_ED_CHANGE_DT$ To 36
|
|
Equ QUOTE_ED_CURR_EXP_DT$ To 37
|
|
Equ QUOTE_ED_NEW_EXP_DT$ To 38
|
|
Equ QUOTE_ED_CHANGE_BY$ To 39
|
|
Equ QUOTE_ED_COMMENTS$ To 40
|
|
Equ QUOTE_NOTES$ To 41
|
|
Equ QUOTE_PROC_DESC$ To 42
|
|
Equ QUOTE_LABEL_DESC$ To 43
|
|
Equ QUOTE_QUOTE_PART_NO$ To 44
|
|
Equ QUOTE_EPI_PART_NO_ORG$ To 45
|
|
Equ QUOTE_VISION_BILL_TO_CUST_NO$ To 46
|
|
Equ QUOTE_COMM_INVOICE_UNIT_PRICE$ To 47
|
|
Equ QUOTE_COMM_INVOICE_REJ_UNIT_PRICE$ To 48
|
|
Equ QUOTE_COMM_INVOICE_ADD_ITEM_DESC$ To 49
|
|
Equ QUOTE_COMM_INVOICE_ADD_ITEM_QTY$ To 50
|
|
Equ QUOTE_COMM_INVOICE_ADD_ITEM_UNIT_PRICE$ To 51
|
|
Equ QUOTE_COMM_INVOICE_TEST_WFR_QTY$ To 52
|
|
Equ QUOTE_COMM_INVOICE_TEST_WFR_DESC$ To 53
|
|
Equ QUOTE_COMM_INVOICE_TEST_WFR_UNIT_PRICE$ To 54
|
|
Equ QUOTE_PROD_VER_NO$ To 55
|