QAD 2017 Enterprise Edition > Technical References > Database Definitions >
  
lgdfc_mstr
Fiscal Control Definition Master
 
 
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
lgdnr_det
Legal Document Address and Sequence ID Detail
 
 
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
lgdtx_det
Legal Document Tax Usage of Simultaneous Op Setup Detail
 
 
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
lgd_mstr
Legal Document Master
 
 
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
lmh_hist
Level Match History
 
 
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
lm_mstr
Level Match Control
 
 
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
lna_det
Production Line Allocation Detail
 
 
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
lnd_det
Production Line Detail
 
 
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
lnf_det
Flow Production Line Preference Detail
 
 
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
Lng
Language
 
 
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
lngd_det
Language Detail
 
 
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
lng_mstr
Language Master
 
 
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
ln_mstr
Line Master
 
 
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
LoadD
Warehousing Load Detail
 
 
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
LoadM
Warehousing Load Master
 
 
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
LoadMasterM
Warehousing Load Master Master
 
 
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
LoadSAddrD
Warehousing Load Setup Address Detail
 
 
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
LoadSetupM
Warehousing Load Setup Master
 
 
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
LoadSItemD
Warehousing Load Setup Item Detail
 
 
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
LocalExitC
Warehousing Local Exit Routine Control
 
 
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
locc_det
Reserved Locations Detail
 
 
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
LocDefD
Warehousing Location Definition Detail
 
 
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
LocDefM
Warehousing Location Definition Master
 
 
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
locd_det
Ending Inventory Balance of a cost calculation period
 
 
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
LocForD
Warehousing Location Forecast Detail
 
 
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