|
|
Field Name
|
Label
|
Col-Label
|
Format
|
Dec
|
|
|
lgdfc__qadc01
|
|
|
x(8)
|
|
|
|
lgdfc__qadc02
|
|
|
x(8)
|
|
|
|
lgdfc__qadc03
|
|
|
x(8)
|
|
|
|
lgdfc__qadd01
|
|
|
->>>>,>>>,>>9.9<<<<<<<<<
|
10
|
|
|
lgdfc__qadd02
|
QAD reserved field
|
|
->>>>,>>>,>>9.9<<<<<<<<<
|
10
|
|
|
lgdfc__qadl01
|
|
|
yes/no
|
|
|
|
lgdfc__qadt01
|
|
|
99/99/99
|
|
|
|
lgdfc_check_price
|
Check Unit Price
|
|
yes/no
|
|
|
|
lgdfc_cr_acct
|
Credit Account
|
Cr Acct
|
x(8)
|
|
|
|
lgdfc_cr_cc
|
Credit Cost Center
|
CC
|
x(4)
|
|
|
|
lgdfc_cr_sub
|
Credit Sub-Account
|
Sub-Acct
|
x(8)
|
|
|
|
lgdfc_desc
|
Description
|
|
x(24)
|
|
|
|
lgdfc_desc1
|
Description
|
|
x(24)
|
|
|
|
lgdfc_domain
|
Domain
|
|
x(8)
|
|
|
|
lgdfc_dr_acct
|
Debit Account
|
Dr Acct
|
x(8)
|
|
|
|
lgdfc_dr_cc
|
Debit Cost Center
|
CC
|
x(4)
|
|
|
|
lgdfc_dr_sub
|
Debit Sub-Account
|
Sub-Acct
|
x(8)
|
|
|
|
lgdfc_id
|
Fiscal Control ID
|
Fiscal ID
|
x(8)
|
|
|
|
lgdfc_inc_pc
|
Include in Periodic Costing
|
|
yes/no
|
|
|
|
lgdfc_inv_type
|
Inventory Type
|
Inv Type
|
x(2)
|
|
|
|
lgdfc_key_type
|
Key Type
|
|
x(2)
|
|
|
|
lgdfc_mod_date
|
Last Modified Date
|
Mod Date
|
99/99/99
|
|
|
|
lgdfc_mod_userid
|
Last Modified User Id
|
|
x(8)
|
|
|
|
lgdfc_user1
|
User Field Character 1
|
|
x(24)
|
|
|
|
lgdfc_user2
|
User Field Character 2
|
|
x(24)
|
|
|
|
lgdfc_userc03
|
User Field Character 3
|
|
x(24)
|
|
|
|
lgdfc_userc04
|
User Field Character 4
|
|
x(24)
|
|
|
|
lgdfc_userd01
|
User Field Decimal 1
|
|
->>>>,>>>,>>9.9<<<<<<<<<
|
10
|
|
|
lgdfc_userd02
|
User Field Decimal 2
|
|
->>>>,>>>,>>9.9<<<<<<<<<
|
10
|
|
|
lgdfc_userl01
|
User Field Logical 1
|
|
yes/no
|
|
|
|
lgdfc_usert01
|
User Field Date 1
|
|
99/99/99
|
|
|
|
oid_lgdfc_mstr
|
|
|
>>>>>>>>>>>>>>>>>>>>>>>>>>>9.9<<<<<<<<<
|
10
|
|
|
Index-Name
|
Uni
|
Field-Name
|
Asc
|
Abbr
|
|
∗
|
lgdfc_id
|
yes
|
lgdfc_domain
|
yes
|
no
|
|
|
|
|
lgdfc_id
|
yes
|
no
|
|
|
lgdfc_inv_type
|
yes
|
lgdfc_domain
|
yes
|
no
|
|
|
|
|
lgdfc_inv_type
|
yes
|
no
|
|
|
|
|
lgdfc_id
|
yes
|
no
|
|
|
oid_lgdfc_mstr
|
yes
|
oid_lgdfc_mstr
|
yes
|
no
|
|
|
Field Name
|
Label
|
Col-Label
|
Format
|
Dec
|
|
|
lgdnr__qadc01
|
QAD Character Field 1
|
|
x(24)
|
|
|
|
lgdnr__qadc02
|
QAD Character Field 2
|
|
x(24)
|
|
|
|
lgdnr__qadd01
|
QAD Decimal Field 1
|
|
->>>,>>>,>>9.99<<
|
10
|
|
|
lgdnr__qadt01
|
QAD Date Field 1
|
|
99/99/99
|
|
|
|
lgdnr_addr
|
Address
|
|
x(8)
|
|
|
|
lgdnr_default
|
Default
|
|
yes/no
|
|
|
|
lgdnr_domain
|
Domain
|
|
x(8)
|
|
|
|
lgdnr_elec
|
Electronic
|
Elec
|
yes/no
|
|
|
|
lgdnr_form_code
|
Legal Document Form Code
|
|
x(2)
|
|
|
|
lgdnr_mod_date
|
Modified Date
|
Mod Date
|
99/99/99
|
|
|
|
lgdnr_mod_userid
|
User ID
|
|
x(8)
|
|
|
|
lgdnr_move
|
Movement
|
|
yes/no
|
|
|
|
lgdnr_seq_id
|
Sequence ID
|
Seq ID
|
x(8)
|
|
|
|
lgdnr_user1
|
User Field Character 1
|
|
x(24)
|
|
|
|
lgdnr_user2
|
User Field Character 2
|
|
x(24)
|
|
|
|
oid_lgdnr_det
|
|
|
>>>>>>>>>>>>>>>>>>>>>>>>>>>9.9<<<<<<<<<
|
10
|
|
|
Index-Name
|
Uni
|
Field-Name
|
Asc
|
Abbr
|
|
∗
|
lgdnr_addr
|
yes
|
lgdnr_domain
|
yes
|
no
|
|
|
|
|
lgdnr_addr
|
yes
|
no
|
|
|
|
|
lgdnr_seq_id
|
yes
|
no
|
|
|
|
|
lgdnr_move
|
yes
|
no
|
|
|
|
|
lgdnr_form_code
|
yes
|
no
|
|
|
oid_lgdnr_det
|
yes
|
oid_lgdnr_det
|
yes
|
no
|
|
|
Field Name
|
Label
|
Col-Label
|
Format
|
Dec
|
|
|
lgdtx__qadc01
|
QAD Character Field 1
|
|
x(24)
|
|
|
|
lgdtx__qadc02
|
QAD Character Field 2
|
|
x(24)
|
|
|
|
lgdtx__qadd01
|
QAD Decimal Field 1
|
|
->>>,>>>,>>9.99<<
|
10
|
|
|
lgdtx__qadt01
|
QAD Date Field 1
|
|
99/99/99
|
|
|
|
lgdtx_active
|
Active
|
|
yes/no
|
|
|
|
lgdtx_consign
|
Consignment
|
|
yes/no
|
|
|
|
lgdtx_custom_legal_doc
|
Custom Legal Document
|
Cust Legal Doc
|
yes/no
|
|
|
|
lgdtx_domain
|
Domain
|
|
x(8)
|
|
|
|
lgdtx_mod_date
|
Modified Date
|
Mod Date
|
99/99/99
|
|
|
|
lgdtx_mod_userid
|
User ID
|
|
x(8)
|
|
|
|
lgdtx_po_nbr
|
Purchase Order
|
Order
|
x(8)
|
|
|
|
lgdtx_sender
|
Sender
|
|
x(8)
|
|
|
|
lgdtx_ship_tax_usage
|
Ship Tax Usage
|
Ship Usage
|
x(8)
|
|
|
|
lgdtx_shipfrom
|
Ship From
|
|
x(8)
|
|
|
|
lgdtx_shipto
|
Ship To
|
|
x(8)
|
|
|
|
lgdtx_so_nbr
|
Sales Order
|
Order
|
x(8)
|
|
|
|
lgdtx_so_tax_usage
|
SO Tax Usage
|
SO Usage
|
x(8)
|
|
|
|
lgdtx_soldto
|
Sold To
|
|
x(8)
|
|
|
|
lgdtx_supplier
|
Supplier
|
|
x(8)
|
|
|
|
lgdtx_tax_type
|
Tax Type
|
|
x(128)
|
|
|
|
lgdtx_type
|
Type
|
|
x(8)
|
|
|
|
lgdtx_user1
|
User Field Character 1
|
|
x(24)
|
|
|
|
lgdtx_user2
|
User Field Character 2
|
|
x(24)
|
|
|
|
oid_lgdtx_det
|
|
|
>>>>>>>>>>>>>>>>>>>>>>>>>>>9.9<<<<<<<<<
|
10
|
|
|
Index-Name
|
Uni
|
Field-Name
|
Asc
|
Abbr
|
|
|
lgdtx_shipfrom
|
no
|
lgdtx_domain
|
yes
|
no
|
|
|
|
|
lgdtx_shipfrom
|
yes
|
no
|
|
∗
|
lgdtx_shipto
|
no
|
lgdtx_domain
|
yes
|
no
|
|
|
|
|
lgdtx_shipto
|
yes
|
no
|
|
|
oid_lgdtx_det
|
yes
|
oid_lgdtx_det
|
yes
|
no
|
|
|
Field Name
|
Label
|
Col-Label
|
Format
|
Dec
|
|
|
lgd__qadc01
|
QAD Character Field 1
|
|
x(24)
|
|
|
|
lgd__qadc02
|
QAD Character Field 2
|
|
x(24)
|
|
|
|
lgd__qadd01
|
QAD Decimal Field 1
|
|
->>>,>>>,>>9.99<<
|
10
|
|
|
lgd__qadt01
|
QAD Date Field 1
|
|
99/99/99
|
|
|
|
lgd_addr
|
Legal Doc Address
|
Address
|
x(8)
|
|
|
|
lgd_amt
|
Legal Doc Amount
|
|
->>>>,>>>,>>9.99<
|
10
|
|
|
lgd_ar_amt
|
AR Amount
|
|
->>>>,>>>,>>9.99<
|
10
|
|
|
lgd_bill
|
Bill-To
|
|
x(8)
|
|
|
|
lgd_bol
|
BOL
|
|
x(18)
|
|
|
|
lgd_cancel_date
|
Void Date
|
|
99/99/99
|
|
|
|
lgd_cancel_inv
|
Void Invoice Number
|
|
x(22)
|
|
|
|
lgd_cancel_rsn
|
Void Reason
|
|
x(8)
|
|
|
|
lgd_cancel_time
|
Void Time
|
|
x(8)
|
|
|
|
lgd_cancel_user
|
Voided By
|
|
x(8)
|
|
|
|
lgd_carrier
|
Carrier
|
|
x(8)
|
|
|
|
lgd_cmtindx
|
Comment Index
|
Comment
|
>>>>>>>9
|
|
|
|
lgd_cncu_batch
|
Batch
|
|
>>>>>>>>>
|
|
|
|
lgd_cr_terms
|
Credit Terms
|
|
x(8)
|
|
|
|
lgd_crdt_notes
|
Credit Notes
|
|
x(20)
|
|
|
|
lgd_cust
|
Customer
|
|
x(8)
|
|
|
|
lgd_doc_model
|
Document Model
|
|
x(8)
|
|
|
|
lgd_doc_type
|
Doc Type
|
|
x(2)
|
|
|
|
lgd_domain
|
Domain
|
|
x(8)
|
|
|
|
lgd_drv
|
Driver Name
|
|
x(24)
|
|
|
|
lgd_dsc_amt
|
Discount Amount
|
Disc Amt
|
->>>>,>>>,>>9.99<
|
10
|
|
|
lgd_due_date
|
Due Date
|
|
99/99/99
|
|
|
|
lgd_effdate
|
Effective Date
|
Eff Date
|
99/99/99
|
|
|
|
lgd_elec
|
Electronic
|
|
yes/no
|
|
|
|
lgd_elec_status
|
Electronic Status
|
|
x(8)
|
|
|
|
lgd_especie
|
Ship Pack Desc
|
|
x(20)
|
|
|
|
lgd_ex_rate
|
Exch Rate
|
|
>>>>,>>>,>>9.9<<<<<<<<<
|
10
|
|
|
lgd_ex_rate2
|
Exch Rate 2
|
|
>>>>,>>>,>>9.9<<<<<<<<<
|
10
|
|
|
lgd_fix_rate
|
Fixed Rate
|
|
yes/no
|
|
|
|
lgd_fob
|
FOB Point
|
FOB
|
x(20)
|
|
|
|
lgd_goods_amt
|
Goods Amount
|
|
->>>>,>>>,>>9.99<
|
10
|
|
|
lgd_gst_id
|
Fed Tax ID
|
|
x(18)
|
|
|
|
lgd_gwt
|
Gross Weight
|
Gross Wt
|
>,>>>,>>9.9<<<<<<<<
|
10
|
|
|
lgd_inv_date
|
Invoice Date
|
Inv Date
|
99/99/99
|
|
|
|
lgd_inv_mov
|
Inventory Movement Code
|
Inv Mov
|
x(8)
|
|
|
|
lgd_inv_nbr
|
Invoice Number
|
Invoice
|
x(22)
|
|
|
|
lgd_lic
|
License
|
|
x(24)
|
|
|
|
lgd_loc
|
Location
|
|
x(8)
|
|
|
|
lgd_mod_date
|
Modified Date
|
Mod Date
|
99/99/99
|
|
|
|
lgd_mod_userid
|
User ID
|
|
x(8)
|
|
|
|
lgd_nbr
|
Legal Doc Nbr
|
Legal Doc
|
x(12)
|
|
|
|
lgd_nbr_cpy
|
Number of Copies
|
|
>9
|
|
|
|
lgd_nwt
|
Net Weight
|
|
>,>>>,>>9.9<<<<<<<<
|
10
|
|
|
lgd_order
|
Order Number
|
|
x(8)
|
|
|
|
lgd_org_doc_nbr
|
Original Legal Document Number
|
Orig Nbr
|
x(20)
|
|
|
|
lgd_posted
|
Posted
|
|
yes/no
|
|
|
|
lgd_prim_addr
|
Orig Addr
|
|
x(8)
|
|
|
|
lgd_prim_doc_typ
|
Orig Doc Type
|
|
x(2)
|
|
|
|
lgd_prim_effdate
|
Orig Effective Date
|
Orig Eff Date
|
99/99/99
|
|
|
|
lgd_prim_nbr
|
Orig Doc
|
|
x(12)
|
|
|
|
lgd_print
|
Printed
|
Print
|
Yes/No
|
|
|
|
lgd_print_date
|
Print Date
|
|
99/99/99
|
|
|
|
lgd_print_time
|
Print Time
|
|
x(8)
|
|
|
|
lgd_print_user
|
Printed By
|
|
x(8)
|
|
|
|
lgd_prt_cmt
|
Print Comments
|
Cmmt
|
yes/no
|
|
|
|
lgd_prt_with_shp
|
Print LD With Shipper
|
|
yes/no
|
|
|
|
lgd_ps_nbr
|
Packing Slip
|
|
x(20)
|
|
|
|
lgd_pst_id
|
PST ID
|
|
x(18)
|
|
|
|
lgd_pst_id_replace
|
PST ID (Subst)
|
|
x(18)
|
|
|
|
lgd_receive_date
|
Receiving Date
|
|
99/99/99
|
|
|
|
lgd_reprint_date
|
Reprint Date
|
|
99/99/99
|
|
|
|
lgd_reprint_rsn
|
Reprint Reason
|
|
x(8)
|
|
|
|
lgd_reprint_time
|
Reprint Time
|
|
x(8)
|
|
|
|
lgd_reprint_user
|
Reprinted By
|
|
x(8)
|
|
|
|
lgd_ret_nbr
|
Return Nbr
|
|
x(20)
|
|
|
|
lgd_rmks
|
Remarks
|
|
x(40)
|
|
|
|
lgd_seq_id
|
Sequence ID
|
|
x(8)
|
|
|
|
lgd_sh_cmtindx
|
Comment Index Shipper
|
Comment
|
>>>>>>>9
|
|
|
|
lgd_ship
|
Ship-To
|
|
x(8)
|
|
|
|
lgd_ship_date
|
Ship Date
|
|
99/99/99
|
|
|
|
lgd_shipfrom
|
Ship From
|
|
x(8)
|
|
|
|
lgd_shipfrom_loc
|
Ship-from Location
|
|
x(8)
|
|
|
|
lgd_shipfrom_site
|
Ship-from Site
|
|
x(8)
|
|
|
|
lgd_shipper_id
|
Shipper ID
|
|
x(20)
|
|
|
|
lgd_shipto_loc
|
Ship-to Location
|
|
x(8)
|
|
|
|
lgd_shipto_site
|
Ship-to Site
|
|
x(8)
|
|
|
|
lgd_shipvia
|
Ship Via
|
|
x(20)
|
|
|
|
lgd_simul
|
Simulation
|
|
yes/no
|
|
|
|
lgd_so_job
|
Sales/Job
|
|
x(8)
|
|
|
|
lgd_status
|
Status
|
|
x(8)
|
|
|
|
lgd_sys_gen
|
System Generated
|
Sys Gen
|
yes/no
|
|
|
|
lgd_tax_date
|
Tax Date
|
|
99/99/99
|
|
|
|
lgd_tax_env
|
Tax Environment
|
Tax Env
|
x(16)
|
|
|
|
lgd_tax_in
|
Tax In
|
|
yes/no
|
|
|
|
lgd_tax_usage
|
Tax Usage
|
TaxUsage
|
x(8)
|
|
|
|
lgd_taxable
|
Taxable
|
|
yes/no
|
|
|
|
lgd_taxc
|
Tax Class
|
TxC
|
x(3)
|
|
|
|
lgd_trans_curr
|
Transaction Currency
|
|
x(3)
|
|
|
|
lgd_trib_replace
|
Tributary Subst
|
|
yes/no
|
|
|
|
lgd_trl_amt
|
Trailer Total Amount
|
|
->>,>>>,>>>,>>9.99
|
10
|
|
|
lgd_trl1_amt
|
Trailer Amt 1
|
|
->>>>,>>>,>>9.99<
|
10
|
|
|
lgd_trl2_amt
|
Trailer Amt 2
|
|
->>>>,>>>,>>9.99<
|
10
|
|
|
lgd_trl3_amt
|
Trailer Amt 3
|
|
->>>>,>>>,>>9.99<
|
10
|
|
|
lgd_type
|
Legal Document Type
|
Type
|
yes/no
|
|
|
|
lgd_user1
|
User Field Character 1
|
|
x(24)
|
|
|
|
lgd_user2
|
User Field Character 2
|
|
x(24)
|
|
|
|
lgd_userid
|
User ID
|
|
x(8)
|
|
|
|
lgd_veh_ref
|
Vehicle Reference
|
|
x(20)
|
|
|
|
lgd_vol
|
Volume
|
|
>,>>>,>>9.9<<<<<<<<
|
10
|
|
|
lgd_vol_um
|
Volume UM
|
Vol UM
|
x(2)
|
|
|
|
lgd_weight_um
|
Weight UM
|
UM
|
x(2)
|
|
|
|
oid_lgd_mstr
|
|
|
>>>>>>>>>>>>>>>>>>>>>>>>>>>9.9<<<<<<<<<
|
10
|
|
|
Index-Name
|
Uni
|
Field-Name
|
Asc
|
Abbr
|
|
|
lgd_addr
|
no
|
lgd_domain
|
yes
|
no
|
|
|
|
|
lgd_addr
|
yes
|
no
|
|
|
|
|
lgd_ship
|
yes
|
no
|
|
|
|
|
lgd_nbr
|
yes
|
no
|
|
|
lgd_doc_type
|
no
|
lgd_domain
|
yes
|
no
|
|
|
|
|
lgd_doc_type
|
yes
|
no
|
|
|
|
|
lgd_shipfrom
|
yes
|
no
|
|
|
|
|
lgd_nbr
|
yes
|
no
|
|
∗
|
lgd_nbr
|
no
|
lgd_domain
|
yes
|
no
|
|
|
|
|
lgd_nbr
|
yes
|
no
|
|
|
|
|
lgd_shipper_id
|
yes
|
no
|
|
|
lgd_receive_date
|
no
|
lgd_domain
|
yes
|
no
|
|
|
|
|
lgd_receive_date
|
yes
|
no
|
|
|
|
|
lgd_posted
|
yes
|
no
|
|
|
lgd_received_nbr
|
no
|
lgd_domain
|
yes
|
no
|
|
|
|
|
lgd_type
|
yes
|
no
|
|
|
|
|
lgd_shipfrom
|
yes
|
no
|
|
|
|
|
lgd_nbr
|
yes
|
no
|
|
|
|
|
lgd_effdate
|
yes
|
no
|
|
|
lgd_shipper
|
no
|
lgd_domain
|
yes
|
no
|
|
|
|
|
lgd_shipper_id
|
yes
|
no
|
|
|
oid_lgd_mstr
|
yes
|
oid_lgd_mstr
|
yes
|
no
|
|
|
Field Name
|
Label
|
Col-Label
|
Format
|
Dec
|
|
|
lmh__qadc01
|
|
|
x(24)
|
|
|
|
lmh__qadc02
|
|
|
x(24)
|
|
|
|
lmh_abs_id
|
ID
|
|
x(20)
|
|
|
|
lmh_domain
|
Domain
|
|
x(8)
|
|
|
|
lmh_level
|
Match Level
|
|
x(1)
|
|
|
|
lmh_mod_date
|
Modified Date
|
|
99/99/99
|
|
|
|
lmh_mod_userid
|
User ID
|
|
x(8)
|
|
|
|
lmh_shipto
|
Ship-To
|
|
x(8)
|
|
|
|
lmh_supplier
|
Supplier
|
|
x(8)
|
|
|
|
lmh_user1
|
User Field Character 1
|
|
x(24)
|
|
|
|
lmh_user2
|
User Field Character 2
|
|
x(24)
|
|
|
|
oid_lmh_hist
|
|
|
>>>>>>>>>>>>>>>>>>>>>>>>>>>9.9<<<<<<<<<
|
10
|
|
|
Index-Name
|
Uni
|
Field-Name
|
Asc
|
Abbr
|
|
∗
|
lmh_supplier_shipper
|
yes
|
lmh_domain
|
yes
|
no
|
|
|
|
|
lmh_shipto
|
yes
|
no
|
|
|
|
|
lmh_supplier
|
yes
|
no
|
|
|
|
|
lmh_abs_id
|
yes
|
no
|
|
|
oid_lmh_hist
|
yes
|
oid_lmh_hist
|
yes
|
no
|
|
|
Field Name
|
Label
|
Col-Label
|
Format
|
Dec
|
|
|
lm__qadc01
|
|
|
x(24)
|
|
|
|
lm__qadc02
|
|
|
x(24)
|
|
|
|
lm_domain
|
Domain
|
|
x(8)
|
|
|
|
lm_level
|
Match Level
|
|
x(1)
|
|
|
|
lm_mod_date
|
Modified Date
|
|
99/99/99
|
|
|
|
lm_mod_userid
|
User ID
|
|
x(8)
|
|
|
|
lm_shipto
|
Ship-To
|
|
x(8)
|
|
|
|
lm_supplier
|
Supplier
|
|
x(8)
|
|
|
|
lm_user1
|
User Field Character 1
|
|
x(24)
|
|
|
|
lm_user2
|
User Field Character 2
|
|
x(24)
|
|
|
|
oid_lm_mstr
|
|
|
>>>>>>>>>>>>>>>>>>>>>>>>>>>9.9<<<<<<<<<
|
10
|
|
|
Index-Name
|
Uni
|
Field-Name
|
Asc
|
Abbr
|
|
∗
|
lm_shipto_supplier
|
yes
|
lm_domain
|
yes
|
no
|
|
|
|
|
lm_shipto
|
yes
|
no
|
|
|
|
|
lm_supplier
|
yes
|
no
|
|
|
oid_lm_mstr
|
yes
|
oid_lm_mstr
|
yes
|
no
|
|
|
Field Name
|
Label
|
Col-Label
|
Format
|
Dec
|
|
|
lna__chr01
|
|
|
x(8)
|
|
|
|
lna__chr02
|
|
|
x(8)
|
|
|
|
lna__dec01
|
|
|
->>>,>>>,>>9.9<<<<<<<<<
|
10
|
|
|
lna__dec02
|
|
|
->>>,>>>,>>9.9<<<<<<<<<
|
10
|
|
|
lna__dte01
|
|
|
99/99/99
|
|
|
|
lna__dte02
|
|
|
99/99/99
|
|
|
|
lna__log01
|
|
|
yes/no
|
|
|
|
lna__log02
|
|
|
yes/no
|
|
|
|
lna__qadc01
|
|
|
x(8)
|
|
|
|
lna__qadc02
|
|
|
x(8)
|
|
|
|
lna__qadd01
|
|
|
->>>,>>>,>>9.9<<<<<<<<<
|
10
|
|
|
lna__qadd02
|
|
|
->>>,>>>,>>9.9<<<<<<<<<
|
10
|
|
|
lna__qadi01
|
|
|
->,>>>,>>9
|
|
|
|
lna__qadi02
|
|
|
->,>>>,>>9
|
|
|
|
lna__qadl01
|
|
|
yes/no
|
|
|
|
lna__qadl02
|
|
|
yes/no
|
|
|
|
lna__qadt01
|
|
|
99/99/99
|
|
|
|
lna__qadt02
|
|
|
99/99/99
|
|
|
|
lna_allocation
|
Allocation%
|
Alloc%
|
>>9.99%
|
10
|
|
|
lna_domain
|
Domain
|
|
x(8)
|
|
|
|
lna_line
|
Line
|
|
x(8)
|
|
|
|
lna_part
|
Item Number
|
|
x(18)
|
|
|
|
lna_site
|
Site
|
|
x(8)
|
|
|
|
lna_user1
|
Ufld1
|
|
x(8)
|
|
|
|
lna_user2
|
Ufld2
|
|
x(8)
|
|
|
|
oid_lna_det
|
|
|
>>>>>>>>>>>>>>>>>>>>>>>>>>>9.9<<<<<<<<<
|
10
|
|
|
Index-Name
|
Uni
|
Field-Name
|
Asc
|
Abbr
|
|
∗
|
lna_siteline
|
yes
|
lna_domain
|
yes
|
no
|
|
|
|
|
lna_site
|
yes
|
no
|
|
|
|
|
lna_line
|
yes
|
no
|
|
|
|
|
lna_part
|
yes
|
no
|
|
|
lna_sitepart
|
no
|
lna_domain
|
yes
|
no
|
|
|
|
|
lna_site
|
yes
|
no
|
|
|
|
|
lna_part
|
yes
|
no
|
|
|
|
|
lna_line
|
yes
|
no
|
|
|
oid_lna_det
|
yes
|
oid_lna_det
|
yes
|
no
|
|
|
Field Name
|
Label
|
Col-Label
|
Format
|
Dec
|
|
|
lnd__chr01
|
|
|
x(8)
|
|
|
|
lnd__chr02
|
|
|
x(8)
|
|
|
|
lnd__chr03
|
|
|
x(8)
|
|
|
|
lnd__chr04
|
|
|
x(8)
|
|
|
|
lnd__chr05
|
|
|
x(8)
|
|
|
|
lnd__dec01
|
|
|
>>>,>>>,>>9.99
|
10
|
|
|
lnd__dec02
|
|
|
>>>,>>>,>>9.99
|
10
|
|
|
lnd__dec03
|
|
|
>>>,>>>,>>9.99
|
10
|
|
|
lnd__log01
|
|
|
yes/no
|
|
|
|
lnd__qadl01
|
|
|
yes/no
|
|
|
|
lnd_bom
|
|
|
x(18)
|
|
|
|
lnd_cmtindx
|
Comment Index
|
Comment
|
>>>>>>>9
|
|
|
|
lnd_domain
|
Domain
|
|
x(8)
|
|
|
|
lnd_expire
|
Expire
|
|
99/99/99
|
|
|
|
lnd_line
|
Line
|
|
x(8)
|
|
|
|
lnd_nbr_lines
|
Number of Production Lines
|
|
>>9.9<
|
2
|
|
|
lnd_part
|
Part
|
|
x(18)
|
|
|
|
lnd_prod_um
|
Production UM
|
UM
|
x(2)
|
|
|
|
lnd_rate
|
Units/Hour
|
|
>>>,>>>,>>9.99
|
10
|
|
|
lnd_routing
|
Routing Code
|
|
x(18)
|
|
|
|
lnd_run
|
Run Crew
|
Run
|
x(8)
|
|
|
|
lnd_run_seq1
|
Run Seq 1
|
|
x(8)
|
|
|
|
lnd_run_seq2
|
2
|
Run Seq 2
|
x(8)
|
|
|
|
lnd_run_size
|
Size
|
|
>>>9
|
|
|
|
lnd_sequence
|
|
|
>>>.99
|
10
|
|
|
lnd_set_size
|
Size
|
|
>>>9
|
|
|
|
lnd_setup
|
Setup Crew
|
Setup
|
x(8)
|
|
|
|
lnd_setup_time
|
Setup Time
|
|
999999
|
|
|
|
lnd_site
|
Site
|
|
x(8)
|
|
|
|
lnd_start
|
Start
|
|
99/99/99
|
|
|
|
lnd_tool
|
Tool ID
|
Tool
|
x(8)
|
|
|
|
lnd_user1
|
Ufld1
|
|
x(50)
|
|
|
|
lnd_user2
|
Ufld2
|
|
x(50)
|
|
|
|
oid_lnd_det
|
|
|
>>>>>>>>>>>>>>>>>>>>>>>>>>>9.9<<<<<<<<<
|
10
|
|
|
Index-Name
|
Uni
|
Field-Name
|
Asc
|
Abbr
|
|
∗
|
lnd_line
|
yes
|
lnd_domain
|
yes
|
no
|
|
|
|
|
lnd_line
|
yes
|
no
|
|
|
|
|
lnd_site
|
yes
|
no
|
|
|
|
|
lnd_part
|
yes
|
no
|
|
|
|
|
lnd_start
|
yes
|
no
|
|
|
lnd_linepart
|
no
|
lnd_domain
|
yes
|
no
|
|
|
|
|
lnd_line
|
yes
|
no
|
|
|
|
|
lnd_part
|
yes
|
no
|
|
|
oid_lnd_det
|
yes
|
oid_lnd_det
|
yes
|
no
|
|
|
Field Name
|
Label
|
Col-Label
|
Format
|
Dec
|
|
|
lnf__qadc01
|
|
|
x(24)
|
|
|
|
lnf__qadc02
|
|
|
x(24)
|
|
|
|
lnf__qadc03
|
|
|
x(24)
|
|
|
|
lnf__qadd01
|
|
|
->>>>,>>>,>>9.9<<<<<<<<<
|
10
|
|
|
lnf__qadi01
|
|
|
->>>>>>>9
|
|
|
|
lnf__qadl01
|
|
|
yes/no
|
|
|
|
lnf__qadt01
|
|
|
99/99/99
|
|
|
|
lnf_domain
|
Domain
|
|
x(8)
|
|
|
|
lnf_mod_date
|
Modified Date
|
Mod Date
|
99/99/99
|
|
|
|
lnf_mod_userid
|
User ID
|
|
x(8)
|
|
|
|
lnf_part
|
Item Number
|
|
x(18)
|
|
|
|
lnf_preference
|
Preference
|
|
>>>>>>>>9
|
|
|
|
lnf_production_line
|
Production Line
|
Line
|
x(8)
|
|
|
|
lnf_site
|
Site
|
|
x(8)
|
|
|
|
lnf_user1
|
User Field Character 1
|
|
x(24)
|
|
|
|
lnf_user2
|
User field character 2
|
|
x(24)
|
|
|
|
lnf_userc03
|
User Field Character 3
|
|
x(24)
|
|
|
|
lnf_userd01
|
User Field Decimal 1
|
|
->>>>,>>>,>>9.9<<<<<<<<<
|
10
|
|
|
lnf_useri01
|
User Field Integer 1
|
|
->>>>>>>9
|
|
|
|
lnf_userl01
|
User Field Logical 1
|
|
yes/no
|
|
|
|
lnf_usert01
|
User Field Date 1
|
|
99/99/99
|
|
|
|
oid_lnf_det
|
|
|
>>>>>>>>>>>>>>>>>>>>>>>>>>>9.9<<<<<<<<<
|
10
|
|
|
Index-Name
|
Uni
|
Field-Name
|
Asc
|
Abbr
|
|
|
lnf_site_part_pref
|
no
|
lnf_domain
|
yes
|
no
|
|
|
|
|
lnf_site
|
yes
|
no
|
|
|
|
|
lnf_part
|
yes
|
no
|
|
|
|
|
lnf_preference
|
yes
|
no
|
|
|
|
|
lnf_production_line
|
yes
|
no
|
|
∗
|
lnf_site_prod_line
|
yes
|
lnf_domain
|
yes
|
no
|
|
|
|
|
lnf_site
|
yes
|
no
|
|
|
|
|
lnf_production_line
|
yes
|
no
|
|
|
|
|
lnf_part
|
yes
|
no
|
|
|
oid_lnf_det
|
yes
|
oid_lnf_det
|
yes
|
no
|
|
|
Field Name
|
Label
|
Col-Label
|
Format
|
Dec
|
|
|
LastModifiedDate
|
Last Modified Date
|
Mod Date
|
99/99/9999
|
|
|
|
LastModifiedTime
|
Last Modified Time
|
Mod Time
|
99999
|
|
|
|
LastModifiedUser
|
Last Modified User
|
Mod User
|
x(20)
|
|
|
|
Lng_ID
|
Record ID
|
|
-99999999999
|
|
|
|
LngAltCode
|
Alternate Code
|
|
x(2)
|
|
|
|
LngCode
|
Language Code
|
Language
|
x(2)
|
|
|
|
LngDescription
|
Description
|
|
x(24)
|
|
|
|
LngDirectory
|
Directory
|
|
x(32)
|
|
|
|
LngIsActive
|
Active
|
Act
|
yes/no
|
|
|
|
LngIsInstalled
|
Installed Language
|
Installed Lang
|
yes/no
|
|
|
|
LngIsSystemLanguage
|
System Language
|
Syst Lang
|
yes/no
|
|
|
|
QADC01
|
|
|
x(40)
|
|
|
|
QADC02
|
|
|
x(255)
|
|
|
|
QADD01
|
|
|
->,>>>,>>9.9999
|
10
|
|
|
QADT01
|
|
|
99/99/9999
|
|
|
|
Index-Name
|
Uni
|
Field-Name
|
Asc
|
Abbr
|
|
|
Code
|
yes
|
LngCode
|
yes
|
no
|
|
∗
|
Prim
|
yes
|
Lng_ID
|
yes
|
no
|
|
|
Field Name
|
Label
|
Col-Label
|
Format
|
Dec
|
|
|
lngd__qadc01
|
|
|
x(8)
|
|
|
|
lngd_dataset
|
Data Set
|
|
x(12)
|
|
|
|
lngd_desc
|
Description
|
|
x(76)
|
|
|
|
lngd_field
|
Field
|
|
x(32)
|
|
|
|
lngd_key1
|
Key Value #1
|
Key #1
|
x(8)
|
|
|
|
lngd_key2
|
Key Value #2
|
Key #2
|
x(8)
|
|
|
|
lngd_key3
|
Key Value #3
|
Key #3
|
x(8)
|
|
|
|
lngd_key4
|
Key Value #4
|
Key #4
|
x(8)
|
|
|
|
lngd_lang
|
Language
|
Lang
|
x(2)
|
|
|
|
lngd_mnemonic
|
Mnemonic
|
|
x(8)
|
|
|
|
lngd_translate2
|
Translation 2
|
|
x(24)
|
|
|
|
lngd_translation
|
Label
|
|
x(24)
|
|
|
|
lngd_user1
|
Ufld1
|
|
x(8)
|
|
|
|
lngd_user2
|
Ufld2
|
|
x(8)
|
|
|
|
oid_lngd_det
|
|
|
>>>>>>>>>>>>>>>>>>>>>>>>>>>9.9<<<<<<<<<
|
10
|
|
|
Index-Name
|
Uni
|
Field-Name
|
Asc
|
Abbr
|
|
∗
|
lngd_det
|
yes
|
lngd_dataset
|
yes
|
no
|
|
|
|
|
lngd_key1
|
yes
|
no
|
|
|
|
|
lngd_key2
|
yes
|
no
|
|
|
|
|
lngd_key3
|
yes
|
no
|
|
|
|
|
lngd_key4
|
yes
|
no
|
|
|
|
|
lngd_field
|
yes
|
no
|
|
|
|
|
lngd_lang
|
yes
|
no
|
|
|
lngd_mnemonic
|
no
|
lngd_desc
|
yes
|
no
|
|
|
|
|
lngd_field
|
yes
|
no
|
|
|
|
|
lngd_lang
|
yes
|
no
|
|
|
|
|
lngd_mnemonic
|
yes
|
no
|
|
|
lngd_trans
|
no
|
lngd_dataset
|
yes
|
no
|
|
|
|
|
lngd_field
|
yes
|
no
|
|
|
|
|
lngd_lang
|
yes
|
no
|
|
|
|
|
lngd_translation
|
yes
|
no
|
|
|
oid_lngd_det
|
yes
|
oid_lngd_det
|
yes
|
no
|
|
|
Field Name
|
Label
|
Col-Label
|
Format
|
Dec
|
|
|
lng__qad01
|
|
|
x(8)
|
|
|
|
lng__qad02
|
|
|
x(8)
|
|
|
|
lng_active
|
Active
|
|
yes/no
|
|
|
|
lng_desc
|
Description
|
|
x(24)
|
|
|
|
lng_dir
|
Directory
|
|
x(32)
|
|
|
|
lng_installed
|
Installed
|
|
yes/no
|
|
|
|
lng_lang
|
Language ID
|
Lang
|
x(2)
|
|
|
|
lng_nbr
|
Language Number
|
|
>>9
|
|
|
|
lng_user1
|
Ufld1
|
|
x(8)
|
|
|
|
lng_user2
|
Ufld2
|
|
x(8)
|
|
|
|
oid_lng_mstr
|
|
|
>>>>>>>>>>>>>>>>>>>>>>>>>>>9.9<<<<<<<<<
|
10
|
|
|
Index-Name
|
Uni
|
Field-Name
|
Asc
|
Abbr
|
|
∗
|
lng_lang
|
yes
|
lng_lang
|
yes
|
no
|
|
|
lng_nbr
|
no
|
lng_nbr
|
yes
|
no
|
|
|
oid_lng_mstr
|
yes
|
oid_lng_mstr
|
yes
|
no
|
|
|
Field Name
|
Label
|
Col-Label
|
Format
|
Dec
|
|
|
ln__chr01
|
|
|
x(8)
|
|
|
|
ln__chr03
|
|
|
x(8)
|
|
|
|
ln__chr04
|
|
|
x(8)
|
|
|
|
ln__chr05
|
|
|
x(8)
|
|
|
|
ln__dec01
|
|
|
>>>,>>>,>>9.99
|
10
|
|
|
ln__dec02
|
|
|
>>>,>>>,>>9.99
|
10
|
|
|
ln__dec03
|
|
|
>>>,>>>,>>9.99
|
10
|
|
|
ln__log01
|
|
|
yes/no
|
|
|
|
ln_autofirm
|
Auto Firm
|
|
yes/no
|
|
|
|
ln_desc
|
Description
|
Description
|
x(24)
|
|
|
|
ln_domain
|
Domain
|
|
x(8)
|
|
|
|
ln_duration_buffer
|
Duration Buffer
|
|
>>>>>9
|
|
|
|
ln_freeze_period
|
Freeze Period
|
|
>>>>>>>>9
|
|
|
|
ln_hrz_end_nbr
|
Horizon End No Periods
|
|
>>9
|
|
|
|
ln_hrz_end_period
|
Horizon End Period
|
|
x(8)
|
|
|
|
ln_hrz_start_nbr
|
Horizon Start No Periods
|
|
>>9
|
|
|
|
ln_hrz_start_period
|
Horizon Start Period
|
|
x(8)
|
|
|
|
ln_kanban_receipts
|
Post Kanban Receipts
|
Post!Kanban!Receipts
|
yes/no
|
|
|
|
ln_last_autofirm
|
Last Auto Firm
|
|
99/99/99
|
|
|
|
ln_line
|
Line
|
|
x(8)
|
|
|
|
ln_nbr_lines
|
Number of Production Lines
|
|
>>9.9<
|
2
|
|
|
ln_rate
|
Units/Hour
|
|
>>>,>>>,>>9.99
|
10
|
|
|
ln_rate_base
|
Line Sequenced
|
|
yes/no
|
|
|
|
ln_rate_code
|
Rate code
|
Rate!Code
|
x(8)
|
|
|
|
ln_run_size_enabled
|
Enable Run Crew Size
|
|
yes/no
|
|
|
|
ln_schedule_code
|
Schedule Code
|
Sched!Code
|
x(8)
|
|
|
|
ln_scheduler
|
Scheduler ID
|
|
x(8)
|
|
|
|
ln_setup_time
|
Setup Time
|
|
999999
|
|
|
|
ln_shift1
|
Shift1
|
|
>>>9.99
|
10
|
|
|
ln_shift2
|
Shift2
|
|
>>>9.99
|
10
|
|
|
ln_shift3
|
Shift3
|
|
>>>9.99
|
10
|
|
|
ln_shift4
|
Shift4
|
|
>>>9.99
|
10
|
|
|
ln_site
|
Site
|
|
x(8)
|
|
|
|
ln_user1
|
Ufld1
|
|
x(50)
|
|
|
|
ln_user2
|
Ufld2
|
|
x(50)
|
|
|
|
oid_ln_mstr
|
|
|
>>>>>>>>>>>>>>>>>>>>>>>>>>>9.9<<<<<<<<<
|
10
|
|
|
Index-Name
|
Uni
|
Field-Name
|
Asc
|
Abbr
|
|
∗
|
ln_linesite
|
yes
|
ln_domain
|
yes
|
no
|
|
|
|
|
ln_line
|
yes
|
no
|
|
|
|
|
ln_site
|
yes
|
no
|
|
|
ln_siteline
|
no
|
ln_domain
|
yes
|
no
|
|
|
|
|
ln_site
|
yes
|
no
|
|
|
|
|
ln_line
|
yes
|
no
|
|
|
oid_ln_mstr
|
yes
|
oid_ln_mstr
|
yes
|
no
|
|
|
Field Name
|
Label
|
Col-Label
|
Format
|
Dec
|
|
|
CarrierRef
|
Carrier Shipment Ref
|
|
x(20)
|
|
|
|
CreateDate
|
Create Date
|
|
99/99/99
|
|
|
|
CreateUserID
|
Created
|
|
x(8)
|
|
|
|
Domain
|
Domain
|
|
x(8)
|
|
|
|
DropOffSeq
|
Drop Off Sequence
|
Drop Off
|
>>>>>9
|
|
|
|
DSet
|
Data Set
|
|
x(12)
|
|
|
|
Line
|
Line/ID
|
|
x(8)
|
|
|
|
LoadNbr
|
Load Number
|
Load Nbr
|
x(8)
|
|
|
|
ModDate
|
Modified
|
|
99/99/99
|
|
|
|
ModUserID
|
Modified
|
|
x(8)
|
|
|
|
Nbr
|
Order
|
|
x(18)
|
|
|
|
oid_LoadD
|
|
|
>>>>>>>>>>>>>>>>>>>>>>>>>>>9.9<<<<<<<<<
|
10
|
|
|
OrdSite
|
Order Site
|
Order!Site
|
x(8)
|
|
|
|
Part
|
Item Number
|
|
x(18)
|
|
|
|
QadC01
|
QAD Field
|
|
x(24)
|
0
|
|
|
QadC02
|
QAD Field
|
|
x(24)
|
0
|
|
|
QadC03
|
QAD Field
|
|
x(24)
|
0
|
|
|
QadC04
|
QAD Field
|
|
x(24)
|
0
|
|
|
QadD01
|
QAD Field
|
|
->>>>,>>>,>>9.99<<<
|
10
|
|
|
QadD02
|
QAD Field
|
|
->>>>,>>>,>>9.99<<<
|
10
|
|
|
QadD03
|
QAD Field
|
|
->>>>,>>>,>>9.99<<<
|
10
|
|
|
QadI01
|
QAD Field
|
|
->,>>>,>>9
|
|
|
|
QadI02
|
QAD Field
|
|
->,>>>,>>9
|
|
|
|
QadI03
|
QAD Field
|
|
->,>>>,>>9
|
|
|
|
QadL01
|
QAD Field
|
|
yes/no
|
|
|
|
QadL02
|
QAD Field
|
|
yes/no
|
|
|
|
QadT01
|
QAD Field
|
|
99/99/99
|
|
|
|
QadT02
|
QAD Field
|
|
99/99/99
|
|
|
|
QadT03
|
QAD Field
|
|
99/99/99
|
|
|
|
Qty
|
Quantity
|
Qty
|
->,>>>,>>9.9<<<<<<<<
|
10
|
|
|
SelNbr
|
Selection Number
|
Sel Nbr
|
x(8)
|
|
|
|
Site
|
Site
|
|
x(8)
|
|
|
|
UM
|
UM
|
|
x(2)
|
|
|
|
UserC01
|
User Field Character 1
|
|
x(24)
|
|
|
|
UserC02
|
User Field Character 2
|
|
x(24)
|
|
|
|
UserC03
|
User Field Character 3
|
|
x(24)
|
|
|
|
UserC04
|
User Field Character 4
|
|
x(24)
|
|
|
|
UserC05
|
User Field Character 5
|
|
x(24)
|
|
|
|
UserD01
|
User Field Decimal 1
|
|
->>>>,>>>,>>9.9<<<<<<<<<
|
10
|
|
|
UserD02
|
User Field Decimal 2
|
|
->>>>,>>>,>>9.9<<<<<<<<<
|
10
|
|
|
UserL01
|
User Field Logical 1
|
|
yes/no
|
|
|
|
UserL02
|
User Field Logical 2
|
|
yes/no
|
|
|
|
UserT01
|
User Field Date 1
|
|
99/99/99
|
|
|
|
UserT02
|
User Field Date 2
|
|
99/99/99
|
|
|
|
Whse
|
Warehouse
|
Whse
|
x(8)
|
|
|
|
Index-Name
|
Uni
|
Field-Name
|
Asc
|
Abbr
|
|
∗
|
Line
|
yes
|
Domain
|
yes
|
no
|
|
|
|
|
LoadNbr
|
yes
|
no
|
|
|
|
|
DropOffSeq
|
yes
|
no
|
|
|
|
|
CarrierRef
|
yes
|
no
|
|
|
|
|
SelNbr
|
yes
|
no
|
|
|
|
|
DSet
|
yes
|
no
|
|
|
|
|
Nbr
|
yes
|
no
|
|
|
|
|
OrdSite
|
yes
|
no
|
|
|
|
|
Line
|
yes
|
no
|
|
|
|
|
Part
|
yes
|
no
|
|
|
oid_LoadD
|
yes
|
oid_LoadD
|
yes
|
no
|
|
|
UsrIdx
|
no
|
Domain
|
yes
|
no
|
|
|
|
|
UserC01
|
yes
|
no
|
|
|
|
|
UserC02
|
yes
|
no
|
|
|
Field Name
|
Label
|
Col-Label
|
Format
|
Dec
|
|
|
ABSID
|
ABS ID
|
|
x(8)
|
|
|
|
CarrierAccount
|
Carrier Account
|
|
x(20)
|
|
|
|
CarrierRef
|
Carrier Shipment Ref
|
|
x(20)
|
|
|
|
CmtIndx
|
Comments
|
|
>>>>>>>9
|
|
|
|
CreateDate
|
Create Date
|
|
99/99/99
|
|
|
|
CreateUserID
|
Created
|
|
x(8)
|
|
|
|
Domain
|
Domain
|
|
x(8)
|
|
|
|
DropOffSeq
|
Drop Off Sequence
|
Drop Off
|
>>>>>9
|
|
|
|
DSet
|
Data Set
|
|
x(12)
|
|
|
|
FOB
|
FOB Point
|
|
x(20)
|
|
|
|
LoadNbr
|
Load Number
|
Load Nbr
|
x(8)
|
|
|
|
ModDate
|
Modified
|
|
99/99/99
|
|
|
|
ModUserID
|
Modified
|
|
x(8)
|
|
|
|
oid_LoadM
|
|
|
>>>>>>>>>>>>>>>>>>>>>>>>>>>9.9<<<<<<<<<
|
10
|
|
|
PaymentType
|
Payment Type
|
|
x(20)
|
|
|
|
QadC01
|
QAD Field
|
|
x(24)
|
0
|
|
|
QadC02
|
QAD Field
|
|
x(24)
|
0
|
|
|
QadC03
|
QAD Field
|
|
x(24)
|
0
|
|
|
QadC04
|
QAD Field
|
|
x(24)
|
0
|
|
|
QadD01
|
QAD Field
|
|
->>>>,>>>,>>9.99<<<
|
10
|
|
|
QadD02
|
QAD Field
|
|
->>>>,>>>,>>9.99<<<
|
10
|
|
|
QadD03
|
QAD Field
|
|
->>>>,>>>,>>9.99<<<
|
10
|
|
|
QadI01
|
QAD Field
|
|
->,>>>,>>9
|
|
|
|
QadI02
|
QAD Field
|
|
->,>>>,>>9
|
|
|
|
QadI03
|
QAD Field
|
|
->,>>>,>>9
|
|
|
|
QadL01
|
QAD Field
|
|
yes/no
|
|
|
|
QadL02
|
QAD Field
|
|
yes/no
|
|
|
|
QadT01
|
QAD Field
|
|
99/99/99
|
|
|
|
QadT02
|
QAD Field
|
|
99/99/99
|
|
|
|
QadT03
|
QAD Field
|
|
99/99/99
|
|
|
|
ShipTo
|
Ship To
|
|
x(8)
|
|
|
|
ShipVia
|
Ship Via
|
|
x(20)
|
|
|
|
Site
|
Site
|
|
x(8)
|
|
|
|
TransMode
|
Mode of Transport
|
|
x(20)
|
|
|
|
UserC01
|
User Field Character 1
|
|
x(24)
|
|
|
|
UserC02
|
User Field Character 2
|
|
x(24)
|
|
|
|
UserC03
|
User Field Character 3
|
|
x(24)
|
|
|
|
UserC04
|
User Field Character 4
|
|
x(24)
|
|
|
|
UserC05
|
User Field Character 5
|
|
x(24)
|
|
|
|
UserD01
|
User Field Decimal 1
|
|
->>>>,>>>,>>9.9<<<<<<<<<
|
10
|
|
|
UserD02
|
User Field Decimal 2
|
|
->>>>,>>>,>>9.9<<<<<<<<<
|
10
|
|
|
UserL01
|
User Field Logical 1
|
|
yes/no
|
|
|
|
UserL02
|
User Field Logical 2
|
|
yes/no
|
|
|
|
UserT01
|
User Field Date 1
|
|
99/99/99
|
|
|
|
UserT02
|
User Field Date 2
|
|
99/99/99
|
|
|
|
VehicleID
|
Vehicle ID
|
|
x(20)
|
|
|
|
Whse
|
Warehouse
|
Whse
|
x(8)
|
|
|
|
Index-Name
|
Uni
|
Field-Name
|
Asc
|
Abbr
|
|
|
ABSID
|
no
|
Domain
|
yes
|
no
|
|
|
|
|
Site
|
yes
|
no
|
|
|
|
|
ABSID
|
yes
|
no
|
|
∗
|
CarrierRef
|
yes
|
Domain
|
yes
|
no
|
|
|
|
|
LoadNbr
|
yes
|
no
|
|
|
|
|
DropOffSeq
|
yes
|
no
|
|
|
|
|
CarrierRef
|
yes
|
no
|
|
|
oid_LoadM
|
yes
|
oid_LoadM
|
yes
|
no
|
|
|
UsrIdx
|
no
|
Domain
|
yes
|
no
|
|
|
|
|
UserC01
|
yes
|
no
|
|
|
|
|
UserC02
|
yes
|
no
|
|
|
Field Name
|
Label
|
Col-Label
|
Format
|
Dec
|
|
|
ArrivalDate
|
Arrival Date
|
|
99/99/99
|
|
|
|
ArrivalTime
|
Time
|
|
99:99
|
|
|
|
CloseDate
|
Closed
|
|
99/99/99
|
|
|
|
CloseUserID
|
Closed By
|
|
x(8)
|
|
|
|
CmtIndx
|
Comments
|
|
>>>>>>>9
|
|
|
|
CreateDate
|
Create Date
|
|
99/99/99
|
|
|
|
CreateUserID
|
Created
|
|
x(8)
|
|
|
|
DepartureDate
|
Departure Date
|
|
99/99/99
|
|
|
|
DepartureTime
|
Time
|
|
99:99
|
|
|
|
Domain
|
Domain
|
|
x(8)
|
|
|
|
FOB
|
FOB Point
|
|
x(20)
|
|
|
|
Language
|
Language
|
|
x(2)
|
|
|
|
LoadNbr
|
Load Number
|
Load Nbr
|
x(8)
|
|
|
|
LoadStatus
|
Status
|
St
|
x(2)
|
|
|
|
LoadType
|
Type
|
|
x(8)
|
|
|
|
MBOL
|
Master Bill
|
MBOL
|
x(20)
|
|
|
|
ModDate
|
Modified
|
|
99/99/99
|
|
|
|
ModUserID
|
Modified
|
|
x(8)
|
|
|
|
oid_LoadMasterM
|
|
|
>>>>>>>>>>>>>>>>>>>>>>>>>>>9.9<<<<<<<<<
|
10
|
|
|
QadC01
|
QAD Field
|
|
x(24)
|
0
|
|
|
QadC02
|
QAD Field
|
|
x(24)
|
0
|
|
|
QadC03
|
QAD Field
|
|
x(24)
|
0
|
|
|
QadC04
|
QAD Field
|
|
x(24)
|
0
|
|
|
QadD01
|
QAD Field
|
|
->>>>,>>>,>>9.99<<<
|
10
|
|
|
QadD02
|
QAD Field
|
|
->>>>,>>>,>>9.99<<<
|
10
|
|
|
QadD03
|
QAD Field
|
|
->>>>,>>>,>>9.99<<<
|
10
|
|
|
QadI01
|
QAD Field
|
|
->,>>>,>>9
|
|
|
|
QadI02
|
QAD Field
|
|
->,>>>,>>9
|
|
|
|
QadI03
|
QAD Field
|
|
->,>>>,>>9
|
|
|
|
QadL01
|
QAD Field
|
|
yes/no
|
|
|
|
QadL02
|
QAD Field
|
|
yes/no
|
|
|
|
QadT01
|
QAD Field
|
|
99/99/99
|
|
|
|
QadT02
|
QAD Field
|
|
99/99/99
|
|
|
|
QadT03
|
QAD Field
|
|
99/99/99
|
|
|
|
Remark
|
Remark
|
Rmk
|
x(40)
|
|
|
|
ShipDate
|
Due Date
|
|
99/99/99
|
|
|
|
ShipTime
|
Time
|
|
99:99
|
|
|
|
ShipVia
|
Ship Via
|
|
x(20)
|
|
|
|
Site
|
Site
|
|
x(8)
|
|
|
|
TransMode
|
Mode of Transport
|
|
x(20)
|
|
|
|
UserC01
|
User Field Character 1
|
|
x(24)
|
|
|
|
UserC02
|
User Field Character 2
|
|
x(24)
|
|
|
|
UserC03
|
User Field Character 3
|
|
x(24)
|
|
|
|
UserC04
|
User Field Character 4
|
|
x(24)
|
|
|
|
UserC05
|
User Field Character 5
|
|
x(24)
|
|
|
|
UserD01
|
User Field Decimal 1
|
|
->>>>,>>>,>>9.9<<<<<<<<<
|
10
|
|
|
UserD02
|
User Field Decimal 2
|
|
->>>>,>>>,>>9.9<<<<<<<<<
|
10
|
|
|
UserL01
|
User Field Logical 1
|
|
yes/no
|
|
|
|
UserL02
|
User Field Logical 2
|
|
yes/no
|
|
|
|
UserT01
|
User Field Date 1
|
|
99/99/99
|
|
|
|
UserT02
|
User Field Date 2
|
|
99/99/99
|
|
|
|
VehicleID
|
Vehicle ID
|
|
x(20)
|
|
|
|
Whse
|
Warehouse
|
Whse
|
x(8)
|
|
|
|
Index-Name
|
Uni
|
Field-Name
|
Asc
|
Abbr
|
|
∗
|
LoadNbr
|
yes
|
Domain
|
yes
|
no
|
|
|
|
|
LoadNbr
|
yes
|
no
|
|
|
LoadStatus
|
no
|
Domain
|
yes
|
no
|
|
|
|
|
LoadStatus
|
yes
|
no
|
|
|
|
|
Site
|
yes
|
no
|
|
|
|
|
Whse
|
yes
|
no
|
|
|
LoadType
|
no
|
Domain
|
yes
|
no
|
|
|
|
|
LoadType
|
yes
|
no
|
|
|
|
|
Site
|
yes
|
no
|
|
|
|
|
Whse
|
yes
|
no
|
|
|
oid_LoadMasterM
|
yes
|
oid_LoadMasterM
|
yes
|
no
|
|
|
SiteWhse
|
no
|
Domain
|
yes
|
no
|
|
|
|
|
Site
|
yes
|
no
|
|
|
|
|
Whse
|
yes
|
no
|
|
|
UsrIdx
|
no
|
Domain
|
yes
|
no
|
|
|
|
|
UserC01
|
yes
|
no
|
|
|
|
|
UserC02
|
yes
|
no
|
|
|
Field Name
|
Label
|
Col-Label
|
Format
|
Dec
|
|
|
Addr
|
Address
|
|
x(8)
|
|
|
|
CreateDate
|
Create Date
|
|
99/99/99
|
|
|
|
CreateUserID
|
Created
|
|
x(8)
|
|
|
|
DistrOrder
|
Distribution Order
|
|
yes/no
|
|
|
|
Domain
|
Domain
|
|
x(8)
|
|
|
|
ModDate
|
Modified
|
|
99/99/99
|
|
|
|
ModUserID
|
Modified
|
|
x(8)
|
|
|
|
oid_LoadSAddrD
|
|
|
>>>>>>>>>>>>>>>>>>>>>>>>>>>9.9<<<<<<<<<
|
10
|
|
|
QadC01
|
QAD Field
|
|
x(24)
|
0
|
|
|
QadC02
|
QAD Field
|
|
x(24)
|
0
|
|
|
QadC03
|
QAD Field
|
|
x(24)
|
0
|
|
|
QadC04
|
QAD Field
|
|
x(24)
|
0
|
|
|
QadD01
|
QAD Field
|
|
->>>>,>>>,>>9.99<<<
|
10
|
|
|
QadD02
|
QAD Field
|
|
->>>>,>>>,>>9.99<<<
|
10
|
|
|
QadD03
|
QAD Field
|
|
->>>>,>>>,>>9.99<<<
|
10
|
|
|
QadI01
|
QAD Field
|
|
->,>>>,>>9
|
|
|
|
QadI02
|
QAD Field
|
|
->,>>>,>>9
|
|
|
|
QadI03
|
QAD Field
|
|
->,>>>,>>9
|
|
|
|
QadL01
|
QAD Field
|
|
yes/no
|
|
|
|
QadL02
|
QAD Field
|
|
yes/no
|
|
|
|
QadT01
|
QAD Field
|
|
99/99/99
|
|
|
|
QadT02
|
QAD Field
|
|
99/99/99
|
|
|
|
QadT03
|
QAD Field
|
|
99/99/99
|
|
|
|
SalesOrder
|
Sales Order
|
|
yes/no
|
|
|
|
Site
|
Site
|
|
x(8)
|
|
|
|
UserC01
|
User Field Character 1
|
|
x(24)
|
|
|
|
UserC02
|
User Field Character 2
|
|
x(24)
|
|
|
|
UserC03
|
User Field Character 3
|
|
x(24)
|
|
|
|
UserC04
|
User Field Character 4
|
|
x(24)
|
|
|
|
UserC05
|
User Field Character 5
|
|
x(24)
|
|
|
|
UserD01
|
User Field Decimal 1
|
|
->>>>,>>>,>>9.9<<<<<<<<<
|
10
|
|
|
UserD02
|
User Field Decimal 2
|
|
->>>>,>>>,>>9.9<<<<<<<<<
|
10
|
|
|
UserL01
|
User Field Logical 1
|
|
yes/no
|
|
|
|
UserL02
|
User Field Logical 2
|
|
yes/no
|
|
|
|
UserT01
|
User Field Date 1
|
|
99/99/99
|
|
|
|
UserT02
|
User Field Date 2
|
|
99/99/99
|
|
|
|
Whse
|
Warehouse
|
Whse
|
x(8)
|
|
|
|
Index-Name
|
Uni
|
Field-Name
|
Asc
|
Abbr
|
|
∗
|
LoadSAddrDIdx
|
yes
|
Domain
|
yes
|
no
|
|
|
|
|
Site
|
yes
|
no
|
|
|
|
|
Whse
|
yes
|
no
|
|
|
|
|
Addr
|
yes
|
no
|
|
|
oid_LoadSAddrD
|
yes
|
oid_LoadSAddrD
|
yes
|
no
|
|
|
UsrIdx
|
no
|
Domain
|
yes
|
no
|
|
|
|
|
UserC01
|
yes
|
no
|
|
|
|
|
UserC02
|
yes
|
no
|
|
|
Field Name
|
Label
|
Col-Label
|
Format
|
Dec
|
|
|
CreateDate
|
Create Date
|
|
99/99/99
|
|
|
|
CreateUserID
|
Created
|
|
x(8)
|
|
|
|
Domain
|
Domain
|
|
x(8)
|
|
|
|
ExclShipViaList
|
Excl Ship Via
|
|
x(72)
|
|
|
|
ModDate
|
Modified
|
|
99/99/99
|
|
|
|
ModUserID
|
Modified
|
|
x(8)
|
|
|
|
oid_LoadSetupM
|
|
|
>>>>>>>>>>>>>>>>>>>>>>>>>>>9.9<<<<<<<<<
|
10
|
|
|
QadC01
|
QAD Field
|
|
x(24)
|
0
|
|
|
QadC02
|
QAD Field
|
|
x(24)
|
0
|
|
|
QadC03
|
QAD Field
|
|
x(24)
|
0
|
|
|
QadC04
|
QAD Field
|
|
x(24)
|
0
|
|
|
QadD01
|
QAD Field
|
|
->>>>,>>>,>>9.99<<<
|
10
|
|
|
QadD02
|
QAD Field
|
|
->>>>,>>>,>>9.99<<<
|
10
|
|
|
QadD03
|
QAD Field
|
|
->>>>,>>>,>>9.99<<<
|
10
|
|
|
QadI01
|
QAD Field
|
|
->,>>>,>>9
|
|
|
|
QadI02
|
QAD Field
|
|
->,>>>,>>9
|
|
|
|
QadI03
|
QAD Field
|
|
->,>>>,>>9
|
|
|
|
QadL01
|
QAD Field
|
|
yes/no
|
|
|
|
QadL02
|
QAD Field
|
|
yes/no
|
|
|
|
QadT01
|
QAD Field
|
|
99/99/99
|
|
|
|
QadT02
|
QAD Field
|
|
99/99/99
|
|
|
|
QadT03
|
QAD Field
|
|
99/99/99
|
|
|
|
Site
|
Site
|
|
x(8)
|
|
|
|
UserC01
|
User Field Character 1
|
|
x(24)
|
|
|
|
UserC02
|
User Field Character 2
|
|
x(24)
|
|
|
|
UserC03
|
User Field Character 3
|
|
x(24)
|
|
|
|
UserC04
|
User Field Character 4
|
|
x(24)
|
|
|
|
UserC05
|
User Field Character 5
|
|
x(24)
|
|
|
|
UserD01
|
User Field Decimal 1
|
|
->>>>,>>>,>>9.9<<<<<<<<<
|
10
|
|
|
UserD02
|
User Field Decimal 2
|
|
->>>>,>>>,>>9.9<<<<<<<<<
|
10
|
|
|
UserL01
|
User Field Logical 1
|
|
yes/no
|
|
|
|
UserL02
|
User Field Logical 2
|
|
yes/no
|
|
|
|
UserT01
|
User Field Date 1
|
|
99/99/99
|
|
|
|
UserT02
|
User Field Date 2
|
|
99/99/99
|
|
|
|
Whse
|
Warehouse
|
Whse
|
x(8)
|
|
|
|
Index-Name
|
Uni
|
Field-Name
|
Asc
|
Abbr
|
|
∗
|
LoadSetupMIdx
|
yes
|
Domain
|
yes
|
no
|
|
|
|
|
Site
|
yes
|
no
|
|
|
|
|
Whse
|
yes
|
no
|
|
|
oid_LoadSetupM
|
yes
|
oid_LoadSetupM
|
yes
|
no
|
|
|
UsrIdx
|
no
|
Domain
|
yes
|
no
|
|
|
|
|
UserC01
|
yes
|
no
|
|
|
|
|
UserC02
|
yes
|
no
|
|
|
Field Name
|
Label
|
Col-Label
|
Format
|
Dec
|
|
|
CreateDate
|
Create Date
|
|
99/99/99
|
|
|
|
CreateUserID
|
Created
|
|
x(8)
|
|
|
|
Domain
|
Domain
|
|
x(8)
|
|
|
|
ModDate
|
Modified
|
|
99/99/99
|
|
|
|
ModUserID
|
Modified
|
|
x(8)
|
|
|
|
oid_LoadSItemD
|
|
|
>>>>>>>>>>>>>>>>>>>>>>>>>>>9.9<<<<<<<<<
|
10
|
|
|
Part
|
Item Number
|
|
x(18)
|
|
|
|
QadC01
|
QAD Field
|
|
x(24)
|
0
|
|
|
QadC02
|
QAD Field
|
|
x(24)
|
0
|
|
|
QadC03
|
QAD Field
|
|
x(24)
|
0
|
|
|
QadC04
|
QAD Field
|
|
x(24)
|
0
|
|
|
QadD01
|
QAD Field
|
|
->>>>,>>>,>>9.99<<<
|
10
|
|
|
QadD02
|
QAD Field
|
|
->>>>,>>>,>>9.99<<<
|
10
|
|
|
QadD03
|
QAD Field
|
|
->>>>,>>>,>>9.99<<<
|
10
|
|
|
QadI01
|
QAD Field
|
|
->,>>>,>>9
|
|
|
|
QadI02
|
QAD Field
|
|
->,>>>,>>9
|
|
|
|
QadI03
|
QAD Field
|
|
->,>>>,>>9
|
|
|
|
QadL01
|
QAD Field
|
|
yes/no
|
|
|
|
QadL02
|
QAD Field
|
|
yes/no
|
|
|
|
QadT01
|
QAD Field
|
|
99/99/99
|
|
|
|
QadT02
|
QAD Field
|
|
99/99/99
|
|
|
|
QadT03
|
QAD Field
|
|
99/99/99
|
|
|
|
Site
|
Site
|
|
x(8)
|
|
|
|
UserC01
|
User Field Character 1
|
|
x(24)
|
|
|
|
UserC02
|
User Field Character 2
|
|
x(24)
|
|
|
|
UserC03
|
User Field Character 3
|
|
x(24)
|
|
|
|
UserC04
|
User Field Character 4
|
|
x(24)
|
|
|
|
UserC05
|
User Field Character 5
|
|
x(24)
|
|
|
|
UserD01
|
User Field Decimal 1
|
|
->>>>,>>>,>>9.9<<<<<<<<<
|
10
|
|
|
UserD02
|
User Field Decimal 2
|
|
->>>>,>>>,>>9.9<<<<<<<<<
|
10
|
|
|
UserL01
|
User Field Logical 1
|
|
yes/no
|
|
|
|
UserL02
|
User Field Logical 2
|
|
yes/no
|
|
|
|
UserT01
|
User Field Date 1
|
|
99/99/99
|
|
|
|
UserT02
|
User Field Date 2
|
|
99/99/99
|
|
|
|
Whse
|
Warehouse
|
Whse
|
x(8)
|
|
|
|
Index-Name
|
Uni
|
Field-Name
|
Asc
|
Abbr
|
|
∗
|
LoadSItemDIdx
|
yes
|
Domain
|
yes
|
no
|
|
|
|
|
Site
|
yes
|
no
|
|
|
|
|
Whse
|
yes
|
no
|
|
|
|
|
Part
|
yes
|
no
|
|
|
oid_LoadSItemD
|
yes
|
oid_LoadSItemD
|
yes
|
no
|
|
|
UsrIdx
|
no
|
Domain
|
yes
|
no
|
|
|
|
|
UserC01
|
yes
|
no
|
|
|
|
|
UserC02
|
yes
|
no
|
|
|
Field Name
|
Label
|
Col-Label
|
Format
|
Dec
|
|
|
BatchOrderExp
|
Batch Order Export
|
|
x(10)
|
|
|
|
BPPickSheet
|
Bulk Pick-Sheet (whbplx01.p)
|
Bulk!Pick-Sheet
|
x(10)
|
|
|
|
CancelShipment
|
Cancel Shipment
|
|
x(10)
|
|
|
|
CreateDate
|
Create Date
|
|
99/99/99
|
|
|
|
CreateUserID
|
Created
|
|
x(8)
|
|
|
|
Domain
|
Domain
|
|
x(8)
|
|
|
|
ICCCAlgo
|
Cycle Count Selection Algorithms (whiccclx.p)
|
Cycle Count!Algorithms
|
x(10)
|
|
|
|
LMTask
|
Task Calculation (whlmlx01.p)
|
Task!Calculation
|
x(10)
|
|
|
|
ModDate
|
Modified
|
|
99/99/99
|
|
|
|
ModUserID
|
Modified
|
|
x(8)
|
|
|
|
oid_LocalExitC
|
|
|
>>>>>>>>>>>>>>>>>>>>>>>>>>>9.9<<<<<<<<<
|
10
|
|
|
OMOrderDetail
|
Order Detail Update (whomlx01.p)
|
Order Detail
|
x(10)
|
|
|
|
OrdSel
|
Order Select
|
|
x(8)
|
|
|
|
OverPick
|
OverPick
|
|
x(8)
|
|
|
|
PreShipList
|
Pre-Shipper List (whbpps01.p)
|
|
x(10)
|
|
|
|
PRUserFields
|
Printer Template User Fields (whprlx01.p)
|
Printer!Template!User Fields
|
x(10)
|
|
|
|
QadC01
|
QAD Field
|
|
X(8)
|
0
|
|
|
QadC02
|
QAD Field
|
|
X(8)
|
0
|
|
|
QadC03
|
QAD Field
|
|
X(8)
|
0
|
|
|
QadC04
|
QAD Field
|
|
X(8)
|
0
|
|
|
QadD01
|
QAD Field
|
|
->>>>,>>>,>>9.99<<<
|
10
|
|
|
QadD02
|
QAD Field
|
|
->>>>,>>>,>>9.99<<<
|
10
|
|
|
QadD03
|
QAD Field
|
|
->>>>,>>>,>>9.99<<<
|
10
|
|
|
QadI01
|
QAD Field
|
|
->,>>>,>>9
|
|
|
|
QadI02
|
QAD Field
|
|
->,>>>,>>9
|
|
|
|
QadI03
|
QAD Field
|
|
->,>>>,>>9
|
|
|
|
QadL01
|
QAD Field
|
|
yes/no
|
|
|
|
QadL02
|
QAD Field
|
|
yes/no
|
|
|
|
QadT01
|
QAD Field
|
|
99/99/99
|
|
|
|
QadT02
|
QAD Field
|
|
99/99/99
|
|
|
|
QadT03
|
QAD Field
|
|
99/99/99
|
|
|
|
ScreenFormat
|
Screen Format
|
|
x(8)
|
|
|
|
SendShipment
|
Send Shipment
|
|
x(10)
|
|
|
|
TaskSort
|
Task Sort
|
|
x(8)
|
|
|
|
TMSControl
|
TMS Integration Control
|
|
x(10)
|
|
|
|
TruckShipment
|
Truck Shipment
|
|
x(10)
|
|
|
|
UniqueID
|
|
|
9
|
|
|
|
User1
|
User 1
|
|
x(8)
|
|
|
|
User2
|
User 2
|
|
x(8)
|
|
|
|
UserC03
|
User Field Character 3
|
|
x(24)
|
|
|
|
UserC04
|
User Field Character 4
|
|
x(24)
|
|
|
|
UserC05
|
User Field Character 5
|
|
x(24)
|
|
|
|
UserD01
|
User Field Decimal 1
|
|
->>>>,>>>,>>9.9<<<<<<<<<
|
10
|
|
|
UserD02
|
User Field Decimal 2
|
|
->>>>,>>>,>>9.9<<<<<<<<<
|
10
|
|
|
UserL01
|
User Field Logical 1
|
|
yes/no
|
|
|
|
UserL02
|
User Field Logical 2
|
|
yes/no
|
|
|
|
UserT01
|
User Field Date 1
|
|
99/99/99
|
|
|
|
UserT02
|
User Field Date 2
|
|
99/99/99
|
|
|
|
Index-Name
|
Uni
|
Field-Name
|
Asc
|
Abbr
|
|
|
oid_LocalExitC
|
yes
|
oid_LocalExitC
|
yes
|
no
|
|
∗
|
UniqueID
|
yes
|
Domain
|
yes
|
no
|
|
|
|
|
UniqueID
|
yes
|
no
|
|
|
UsrIdx
|
no
|
Domain
|
yes
|
no
|
|
|
|
|
User1
|
yes
|
no
|
|
|
|
|
User2
|
yes
|
no
|
|
|
Field Name
|
Label
|
Col-Label
|
Format
|
Dec
|
|
|
locc__qadc01
|
|
|
x(24)
|
|
|
|
locc__qadd01
|
|
|
->>>>,>>>,>>9.9<<<<<<<<<
|
10
|
|
|
locc__qadi01
|
|
|
->>>>>>9
|
|
|
|
locc__qadl01
|
|
|
yes/no
|
|
|
|
locc__qadt01
|
|
|
99/99/99
|
|
|
|
locc_addr
|
Address
|
|
x(8)
|
|
|
|
locc_domain
|
Domain
|
|
x(8)
|
|
|
|
locc_loc
|
Reserved Location
|
Reserved!Location
|
x(8)
|
|
|
|
locc_mod_date
|
Modified Date
|
Mod Date
|
99/99/99
|
|
|
|
locc_mod_userid
|
User ID
|
|
x(8)
|
|
|
|
locc_primary_loc
|
Primary Location
|
Primary!Location
|
yes/no
|
|
|
|
locc_site
|
Site
|
|
x(8)
|
|
|
|
locc_userc01
|
User Field 1
|
|
x(24)
|
|
|
|
locc_userc02
|
User Field 2
|
|
x(24)
|
|
|
|
locc_userd01
|
User Field Decimal 1
|
|
->>>>,>>>,>>9.9<<<<<<<<<
|
10
|
|
|
locc_useri01
|
User Field Integer 1
|
|
->>>>>>9
|
|
|
|
locc_userl01
|
User Field Logical 1
|
|
yes/no
|
|
|
|
locc_usert01
|
User Field Date 1
|
|
99/99/99
|
|
|
|
oid_locc_det
|
|
|
>>>>>>>>>>>>>>>>>>>>>>>>>>>9.9<<<<<<<<<
|
10
|
|
|
Index-Name
|
Uni
|
Field-Name
|
Asc
|
Abbr
|
|
|
locc_addr_site
|
yes
|
locc_domain
|
yes
|
no
|
|
|
|
|
locc_addr
|
yes
|
no
|
|
|
|
|
locc_site
|
yes
|
no
|
|
|
|
|
locc_loc
|
yes
|
no
|
|
|
locc_primary
|
no
|
locc_domain
|
yes
|
no
|
|
|
|
|
locc_addr
|
yes
|
no
|
|
|
|
|
locc_site
|
yes
|
no
|
|
|
|
|
locc_primary_loc
|
yes
|
no
|
|
∗
|
locc_site_loc
|
yes
|
locc_domain
|
yes
|
no
|
|
|
|
|
locc_site
|
yes
|
no
|
|
|
|
|
locc_loc
|
yes
|
no
|
|
|
|
|
locc_addr
|
yes
|
no
|
|
|
oid_locc_det
|
yes
|
oid_locc_det
|
yes
|
no
|
|
|
Field Name
|
Label
|
Col-Label
|
Format
|
Dec
|
|
|
CreateDate
|
Create Date
|
|
99/99/99
|
|
|
|
CreateUserID
|
Created
|
|
x(8)
|
|
|
|
Description
|
Description
|
|
x(64)
|
|
|
|
Domain
|
Domain
|
|
x(8)
|
|
|
|
LDFormat
|
Format
|
|
X(8)
|
|
|
|
LDInc
|
Increment
|
Inc
|
->9
|
|
|
|
LDMax
|
Maximum Value
|
Max
|
X(8)
|
|
|
|
LDMin
|
Minimum Value
|
Min
|
X(8)
|
|
|
|
LDSeq
|
Seq
|
|
9
|
|
|
|
LDSet
|
Type
|
T
|
x(1)
|
|
|
|
LDType
|
Type
|
T
|
x(1)
|
|
|
|
LocDef
|
Location Definition
|
Location!Definition
|
X(8)
|
|
|
|
ModDate
|
Modified Date
|
Mod Date
|
99/99/99
|
|
|
|
ModUserID
|
User ID
|
|
x(8)
|
|
|
|
oid_LocDefD
|
|
|
>>>>>>>>>>>>>>>>>>>>>>>>>>>9.9<<<<<<<<<
|
10
|
|
|
QadC01
|
QAD Field
|
|
X(8)
|
0
|
|
|
QadC02
|
QAD Field
|
|
X(8)
|
0
|
|
|
QadC03
|
QAD Field
|
|
X(8)
|
0
|
|
|
QadC04
|
QAD Field
|
|
X(8)
|
0
|
|
|
QadD01
|
QAD Field
|
|
->>>>,>>>,>>9.99<<<
|
10
|
|
|
QadD02
|
QAD Field
|
|
->>>>,>>>,>>9.99<<<
|
10
|
|
|
QadD03
|
QAD Field
|
|
->>>>,>>>,>>9.99<<<
|
10
|
|
|
QadI01
|
QAD Field
|
|
->,>>>,>>9
|
|
|
|
QadI02
|
QAD Field
|
|
->,>>>,>>9
|
|
|
|
QadI03
|
QAD Field
|
|
->,>>>,>>9
|
|
|
|
QadL01
|
QAD Field
|
|
yes/no
|
|
|
|
QadL02
|
QAD Field
|
|
yes/no
|
|
|
|
QadT01
|
QAD Field
|
|
99/99/99
|
|
|
|
QadT02
|
QAD Field
|
|
99/99/99
|
|
|
|
QadT03
|
QAD Field
|
|
99/99/99
|
|
|
|
User1
|
User 1
|
|
x(8)
|
|
|
|
User2
|
User 2
|
|
x(8)
|
|
|
|
UserC03
|
User Field Character 3
|
|
x(24)
|
|
|
|
UserC04
|
User Field Character 4
|
|
x(24)
|
|
|
|
UserC05
|
User Field Character 5
|
|
x(24)
|
|
|
|
UserD01
|
User Field Decimal 1
|
|
->>>>,>>>,>>9.9<<<<<<<<<
|
10
|
|
|
UserD02
|
User Field Decimal 2
|
|
->>>>,>>>,>>9.9<<<<<<<<<
|
10
|
|
|
UserL01
|
User Field Logical 1
|
|
yes/no
|
|
|
|
UserL02
|
User Field Logical 2
|
|
yes/no
|
|
|
|
UserT01
|
User Field Date 1
|
|
99/99/99
|
|
|
|
UserT02
|
User Field Date 2
|
|
99/99/99
|
|
|
|
Index-Name
|
Uni
|
Field-Name
|
Asc
|
Abbr
|
|
∗
|
LocDefSeq
|
yes
|
Domain
|
yes
|
no
|
|
|
|
|
LocDef
|
yes
|
no
|
|
|
|
|
LDSeq
|
yes
|
no
|
|
|
oid_LocDefD
|
yes
|
oid_LocDefD
|
yes
|
no
|
|
|
UsrIdx
|
no
|
Domain
|
yes
|
no
|
|
|
|
|
User1
|
yes
|
no
|
|
|
|
|
User2
|
yes
|
no
|
|
|
Field Name
|
Label
|
Col-Label
|
Format
|
Dec
|
|
|
CmtIndx
|
Comments
|
|
>>>>>>>9
|
|
|
|
CreateDate
|
Create Date
|
|
99/99/99
|
|
|
|
CreateUserID
|
Created
|
|
x(8)
|
|
|
|
Description
|
Description
|
|
x(24)
|
|
|
|
Domain
|
Domain
|
|
x(8)
|
|
|
|
LocDef
|
Location Definition
|
Location!Definition
|
X(8)
|
|
|
|
ModDate
|
Modified
|
|
99/99/99
|
|
|
|
ModUserID
|
Modified
|
|
x(8)
|
|
|
|
oid_LocDefM
|
|
|
>>>>>>>>>>>>>>>>>>>>>>>>>>>9.9<<<<<<<<<
|
10
|
|
|
QadC01
|
QAD Field
|
|
X(8)
|
0
|
|
|
QadC02
|
QAD Field
|
|
X(8)
|
0
|
|
|
QadC03
|
QAD Field
|
|
X(8)
|
0
|
|
|
QadC04
|
QAD Field
|
|
X(8)
|
0
|
|
|
QadD01
|
QAD Field
|
|
->>>>,>>>,>>9.99<<<
|
10
|
|
|
QadD02
|
QAD Field
|
|
->>>>,>>>,>>9.99<<<
|
10
|
|
|
QadD03
|
QAD Field
|
|
->>>>,>>>,>>9.99<<<
|
10
|
|
|
QadI01
|
QAD Field
|
|
->,>>>,>>9
|
|
|
|
QadI02
|
QAD Field
|
|
->,>>>,>>9
|
|
|
|
QadI03
|
QAD Field
|
|
->,>>>,>>9
|
|
|
|
QadL01
|
QAD Field
|
|
yes/no
|
|
|
|
QadL02
|
QAD Field
|
|
yes/no
|
|
|
|
QadT01
|
QAD Field
|
|
99/99/99
|
|
|
|
QadT02
|
QAD Field
|
|
99/99/99
|
|
|
|
QadT03
|
QAD Field
|
|
99/99/99
|
|
|
|
User1
|
User 1
|
|
x(8)
|
|
|
|
User2
|
User 2
|
|
x(8)
|
|
|
|
UserC03
|
User Field Character 3
|
|
x(24)
|
|
|
|
UserC04
|
User Field Character 4
|
|
x(24)
|
|
|
|
UserC05
|
User Field Character 5
|
|
x(24)
|
|
|
|
UserD01
|
User Field Decimal 1
|
|
->>>>,>>>,>>9.9<<<<<<<<<
|
10
|
|
|
UserD02
|
User Field Decimal 2
|
|
->>>>,>>>,>>9.9<<<<<<<<<
|
10
|
|
|
UserL01
|
User Field Logical 1
|
|
yes/no
|
|
|
|
UserL02
|
User Field Logical 2
|
|
yes/no
|
|
|
|
UserT01
|
User Field Date 1
|
|
99/99/99
|
|
|
|
UserT02
|
User Field Date 2
|
|
99/99/99
|
|
|
|
Index-Name
|
Uni
|
Field-Name
|
Asc
|
Abbr
|
|
∗
|
LocDef
|
yes
|
Domain
|
yes
|
no
|
|
|
|
|
LocDef
|
yes
|
no
|
|
|
oid_LocDefM
|
yes
|
oid_LocDefM
|
yes
|
no
|
|
|
UsrIdx
|
no
|
User1
|
yes
|
no
|
|
|
|
|
User2
|
yes
|
no
|
|
|
Field Name
|
Label
|
Col-Label
|
Format
|
Dec
|
|
|
locd__qadc02
|
|
|
x(24)
|
|
|
|
locd__qadc03
|
|
|
x(24)
|
|
|
|
locd_acct
|
Account
|
Acct
|
x(8)
|
|
|
|
locd_cc
|
Cost Center
|
CC
|
x(4)
|
|
|
|
locd_domain
|
Domain
|
|
x(8)
|
|
|
|
locd_loc
|
Location
|
|
x(8)
|
|
|
|
locd_mod_date
|
Modified Date
|
Mod Date
|
99/99/99
|
|
|
|
locd_mod_userid
|
User ID
|
|
x(8)
|
|
|
|
locd_part
|
Item Number
|
|
x(18)
|
|
|
|
locd_qty_oh
|
Qty On Hand
|
|
->,>>>,>>9.9<<<<<<<<
|
10
|
|
|
locd_qty_rcvd
|
Period Qty Received
|
|
->,>>>,>>9.9<<<<<<<<
|
10
|
|
|
locd_site
|
Site
|
|
x(8)
|
|
|
|
locd_sub
|
Sub-Account
|
Sub-Acct
|
x(8)
|
|
|
|
locd_uncons_cn_it_qty_oh
|
Consignment In Transit Qty
|
|
->,>>>,>>9.9<<<<<<<<
|
10
|
|
|
locd_uncons_cn_qty_oh
|
Consignment Qty Unconsumed
|
|
->,>>>,>>9.9<<<<<<<<
|
10
|
|
|
locd_uncons_qty_oh
|
Qty Unconsummed Current
|
|
->,>>>,>>9.9<<<<<<<<
|
10
|
|
|
locd_user1
|
User Field Character 1
|
|
x(24)
|
|
|
|
locd_user2
|
User Field Character 2
|
|
x(24)
|
|
|
|
oid_glccp_det
|
Identifier Cost Calculation Period
|
|
>>>>>>>>>>>>>>>>>>>>>>>>>>>9.9<<<<<<<<<
|
10
|
|
|
oid_locd_det
|
Identifier Period Ending Inventory Balance
|
|
>>>>>>>>>>>>>>>>>>>>>>>>>>>9.9<<<<<<<<<
|
10
|
|
|
Index-Name
|
Uni
|
Field-Name
|
Asc
|
Abbr
|
|
|
locd_glccp_acct
|
no
|
oid_glccp_det
|
yes
|
no
|
|
|
|
|
locd_acct
|
yes
|
no
|
|
|
|
|
locd_sub
|
yes
|
no
|
|
|
|
|
locd_cc
|
yes
|
no
|
|
|
locd_glccp_pt_si_loc
|
yes
|
oid_glccp_det
|
yes
|
no
|
|
|
|
|
locd_part
|
yes
|
no
|
|
|
|
|
locd_site
|
yes
|
no
|
|
|
|
|
locd_loc
|
yes
|
no
|
|
|
locd_glccp_si_loc_pt
|
no
|
oid_glccp_det
|
yes
|
no
|
|
|
|
|
locd_site
|
yes
|
no
|
|
|
|
|
locd_loc
|
yes
|
no
|
|
|
|
|
locd_part
|
yes
|
no
|
|
|
locd_part_loc_cnqty
|
no
|
locd_domain
|
yes
|
no
|
|
|
|
|
locd_part
|
yes
|
no
|
|
|
|
|
locd_site
|
yes
|
no
|
|
|
|
|
locd_loc
|
yes
|
no
|
|
|
|
|
locd_uncons_cn_qty_oh
|
yes
|
no
|
|
|
locd_part_loc_itqty
|
no
|
locd_domain
|
yes
|
no
|
|
|
|
|
locd_part
|
yes
|
no
|
|
|
|
|
locd_site
|
yes
|
no
|
|
|
|
|
locd_loc
|
yes
|
no
|
|
|
|
|
locd_uncons_cn_it_qty_oh
|
yes
|
no
|
|
|
locd_part_loc_unqty
|
no
|
locd_domain
|
yes
|
no
|
|
|
|
|
locd_part
|
yes
|
no
|
|
|
|
|
locd_site
|
yes
|
no
|
|
|
|
|
locd_loc
|
yes
|
no
|
|
|
|
|
locd_uncons_qty_oh
|
yes
|
no
|
|
∗
|
oid_locd_det
|
yes
|
oid_locd_det
|
yes
|
no
|
|
|
Field Name
|
Label
|
Col-Label
|
Format
|
Dec
|
|
|
AltUM
|
Alt UM
|
Alt!UM
|
x(2)
|
|
|
|
CreateDate
|
Create Date
|
|
99/99/99
|
|
|
|
CreateUserID
|
Created
|
|
x(8)
|
|
|
|
Domain
|
Domain
|
|
x(8)
|
|
|
|
DSet
|
Data Set
|
|
x(12)
|
|
|
|
ForType
|
Type
|
|
X(2)
|
|
|
|
Line
|
Line/ID
|
|
x(8)
|
|
|
|
Loc
|
Location
|
|
x(8)
|
|
|
|
Lot
|
Lot/Serial
|
|
x(18)
|
|
|
|
ModDate
|
Modified
|
|
99/99/99
|
|
|
|
ModUserID
|
Modified
|
|
x(8)
|
|
|
|
Nbr
|
Order
|
|
x(18)
|
|
|
|
oid_LocForD
|
|
|
>>>>>>>>>>>>>>>>>>>>>>>>>>>9.9<<<<<<<<<
|
10
|
|
|
OrdSite
|
Order Site
|
Order!Site
|
x(8)
|
|
|
|
Part
|
Item Number
|
|
x(18)
|
|
|
|
QadC01
|
QAD Field
|
|
X(8)
|
0
|
|
|
QadC02
|
QAD Field
|
|
X(8)
|
0
|
|
|
QadC03
|
QAD Field
|
|
X(8)
|
0
|
|
|
QadC04
|
QAD Field
|
|
X(8)
|
0
|
|
|
QadD01
|
QAD Field
|
|
->>>>,>>>,>>9.99<<<
|
10
|
|
|
QadD02
|
QAD Field
|
|
->>>>,>>>,>>9.99<<<
|
10
|
|
|
QadD03
|
QAD Field
|
|
->>>>,>>>,>>9.99<<<
|
10
|
|
|
QadI01
|
QAD Field
|
|
->,>>>,>>9
|
|
|
|
QadI02
|
QAD Field
|
|
->,>>>,>>9
|
|
|
|
QadI03
|
QAD Field
|
|
->,>>>,>>9
|
|
|
|
QadL01
|
QAD Field
|
|
yes/no
|
|
|
|
QadL02
|
QAD Field
|
|
yes/no
|
|
|
|
QadT01
|
QAD Field
|
|
99/99/99
|
|
|
|
QadT02
|
QAD Field
|
|
99/99/99
|
|
|
|
QadT03
|
QAD Field
|
|
99/99/99
|
|
|
|
Quantity
|
Quantity
|
|
->>>,>>9.9<<<<<<
|
10
|
|
|
Ref
|
Reference
|
|
x(8)
|
|
|
|
Site
|
Site
|
|
x(8)
|
|
|
|
User1
|
User 1
|
|
x(8)
|
|
|
|
User2
|
User 2
|
|
x(8)
|
|
|
|
UserC03
|
User Field Character 3
|
|
x(24)
|
|
|
|
UserC04
|
User Field Character 4
|
|
x(24)
|
|
|
|
UserC05
|
User Field Character 5
|
|
x(24)
|
|
|
|
UserD01
|
User Field Decimal 1
|
|
->>>>,>>>,>>9.9<<<<<<<<<
|
10
|
|
|
UserD02
|
User Field Decimal 2
|
|
->>>>,>>>,>>9.9<<<<<<<<<
|
10
|
|
|
UserL01
|
User Field Logical 1
|
|
yes/no
|
|
|
|
UserL02
|
User Field Logical 2
|
|
yes/no
|
|
|
|
UserT01
|
User Field Date 1
|
|
99/99/99
|
|
|
|
UserT02
|
User Field Date 2
|
|
99/99/99
|
|
|
|
Index-Name
|
Uni
|
Field-Name
|
Asc
|
Abbr
|
|
∗
|
LocForIdx
|
yes
|
Domain
|
yes
|
no
|
|
|
|
|
ForType
|
yes
|
no
|
|
|
|
|
DSet
|
yes
|
no
|
|
|
|
|
Nbr
|
yes
|
no
|
|
|
|
|
Line
|
yes
|
no
|
|
|
|
|
Site
|
yes
|
no
|
|
|
|
|
Loc
|
yes
|
no
|
|
|
|
|
Part
|
yes
|
no
|
|
|
|
|
Lot
|
yes
|
no
|
|
|
|
|
Ref
|
yes
|
no
|
|
|
oid_LocForD
|
yes
|
oid_LocForD
|
yes
|
no
|
|
|
OrderIdx
|
no
|
Domain
|
yes
|
no
|
|
|
|
|
DSet
|
yes
|
no
|
|
|
|
|
Nbr
|
yes
|
no
|
|
|
|
|
Line
|
yes
|
no
|
|
|
Part
|
no
|
Domain
|
yes
|
no
|
|
|
|
|
Part
|
yes
|
no
|
|
|
TypeOrder
|
no
|
Domain
|
yes
|
no
|
|
|
|
|
ForType
|
yes
|
no
|
|
|
|
|
DSet
|
yes
|
no
|
|
|
|
|
Nbr
|
yes
|
no
|
|
|
|
|
Site
|
yes
|
no
|
|
|
|
|
Line
|
yes
|
no
|
|
|
|
|
Part
|
yes
|
no
|
|
|
|
|
Lot
|
yes
|
no
|
|
|
|
|
Ref
|
yes
|
no
|
|
|
UsrIdx
|
no
|
Domain
|
yes
|
no
|
|
|
|
|
User1
|
yes
|
no
|
|
|
|
|
User2
|
yes
|
no
|