QAD 2017 Enterprise Edition > Technical References > Database Definitions >
  
KPISliceDet
KPI Slice Details
 
 
Field Name
Label
Col-Label
Format
Dec
 
CustomCombo0
Custom Combo Field
 
x(20)
 
 
CustomCombo1
Custom Combo Field
 
x(20)
 
 
CustomCombo2
Custom Combo Field
 
x(20)
 
 
CustomCombo3
Custom Combo Field
 
x(20)
 
 
CustomCombo4
Custom Combo Field
 
x(20)
 
 
CustomCombo5
Custom Combo Field
 
x(20)
 
 
CustomCombo6
Custom Combo Field
 
x(20)
 
 
CustomCombo7
Custom Combo Field
 
x(20)
 
 
CustomCombo8
Custom Combo Field
 
x(20)
 
 
CustomCombo9
Custom Combo Field
 
x(20)
 
 
CustomDate0
Custom Date Field
 
99/99/9999
 
 
CustomDate1
Custom Date Field
 
99/99/9999
 
 
CustomDate2
Custom Date Field
 
99/99/9999
 
 
CustomDate3
Custom Date Field
 
99/99/9999
 
 
CustomDate4
Custom Date Field
 
99/99/9999
 
 
CustomDecimal0
Custom Decimal Field
 
->,>>>,>>9.99
4
 
CustomDecimal1
Custom Decimal Field
 
->,>>>,>>9.99
4
 
CustomDecimal2
Custom Decimal Field
 
->,>>>,>>9.99
4
 
CustomDecimal3
Custom Decimal Field
 
->,>>>,>>9.99
4
 
CustomDecimal4
Custom Decimal Field
 
->,>>>,>>9.99
4
 
CustomInteger0
Custom Integer Field
 
->,>>>,>>9
 
 
CustomInteger1
Custom Integer Field
 
->,>>>,>>9
 
 
CustomInteger2
Custom Integer Field
 
->,>>>,>>9
 
 
CustomInteger3
Custom Integer Field
 
->,>>>,>>9
 
 
CustomInteger4
Custom Integer Field
 
->,>>>,>>9
 
 
CustomLong0
Custom Long Field
 
x(255)
 
 
CustomLong1
Custom Long Field
 
x(255)
 
 
CustomNote
Custom Note Field
 
x(2000)
 
 
CustomShort0
Custom Short Field
 
x(20)
 
 
CustomShort1
Custom Short Field
 
x(20)
 
 
CustomShort2
Custom Short Field
 
x(20)
 
 
CustomShort3
Custom Short Field
 
x(20)
 
 
CustomShort4
Custom Short Field
 
x(20)
 
 
CustomShort5
Custom Short Field
 
x(20)
 
 
CustomShort6
Custom Short Field
 
x(20)
 
 
CustomShort7
Custom Short Field
 
x(20)
 
 
CustomShort8
Custom Short Field
 
x(20)
 
 
CustomShort9
Custom Short Field
 
x(20)
 
 
FRWAnCode_ID
Link to FRWAnCode
 
-99999999999
 
 
KPISlice_ID
Link to KPISlice
 
-99999999999
 
 
KPISliceDet_ID
Record ID
 
-99999999999
 
 
LastModifiedDate
Last Modified Date
Mod Date
99/99/9999
 
 
LastModifiedTime
Last Modified Time
Mod Time
99999
 
 
LastModifiedUser
Last Modified User
Mod User
x(20)
 
 
QADC01
 
 
x(40)
 
 
QADC02
 
 
x(255)
 
 
QADD01
 
 
->,>>>,>>9.9999
10
 
QADT01
 
 
99/99/9999
 
 
 
 
Index-Name
Uni
Field-Name
Asc
Abbr
 
AnCodeIdx
no
FRWAnCode_ID
yes
no
 ∗
Prim
yes
KPISliceDet_ID
yes
no
 
SliceIdx
no
KPISlice_ID
yes
no
 
UniqIdx
yes
KPISlice_ID
yes
no
 
 
 
FRWAnCode_ID
yes
no
KPISliceLink
KPI Slice Link
 
 
Field Name
Label
Col-Label
Format
Dec
 
CustomCombo0
Custom Combo Field
 
x(20)
 
 
CustomCombo1
Custom Combo Field
 
x(20)
 
 
CustomCombo2
Custom Combo Field
 
x(20)
 
 
CustomCombo3
Custom Combo Field
 
x(20)
 
 
CustomCombo4
Custom Combo Field
 
x(20)
 
 
CustomCombo5
Custom Combo Field
 
x(20)
 
 
CustomCombo6
Custom Combo Field
 
x(20)
 
 
CustomCombo7
Custom Combo Field
 
x(20)
 
 
CustomCombo8
Custom Combo Field
 
x(20)
 
 
CustomCombo9
Custom Combo Field
 
x(20)
 
 
CustomDate0
Custom Date Field
 
99/99/9999
 
 
CustomDate1
Custom Date Field
 
99/99/9999
 
 
CustomDate2
Custom Date Field
 
99/99/9999
 
 
CustomDate3
Custom Date Field
 
99/99/9999
 
 
CustomDate4
Custom Date Field
 
99/99/9999
 
 
CustomDecimal0
Custom Decimal Field
 
->,>>>,>>9.99
4
 
CustomDecimal1
Custom Decimal Field
 
->,>>>,>>9.99
4
 
CustomDecimal2
Custom Decimal Field
 
->,>>>,>>9.99
4
 
CustomDecimal3
Custom Decimal Field
 
->,>>>,>>9.99
4
 
CustomDecimal4
Custom Decimal Field
 
->,>>>,>>9.99
4
 
CustomInteger0
Custom Integer Field
 
->,>>>,>>9
 
 
CustomInteger1
Custom Integer Field
 
->,>>>,>>9
 
 
CustomInteger2
Custom Integer Field
 
->,>>>,>>9
 
 
CustomInteger3
Custom Integer Field
 
->,>>>,>>9
 
 
CustomInteger4
Custom Integer Field
 
->,>>>,>>9
 
 
CustomLong0
Custom Long Field
 
x(255)
 
 
CustomLong1
Custom Long Field
 
x(255)
 
 
CustomNote
Custom Note Field
 
x(2000)
 
 
CustomShort0
Custom Short Field
 
x(20)
 
 
CustomShort1
Custom Short Field
 
x(20)
 
 
CustomShort2
Custom Short Field
 
x(20)
 
 
CustomShort3
Custom Short Field
 
x(20)
 
 
CustomShort4
Custom Short Field
 
x(20)
 
 
CustomShort5
Custom Short Field
 
x(20)
 
 
CustomShort6
Custom Short Field
 
x(20)
 
 
CustomShort7
Custom Short Field
 
x(20)
 
 
CustomShort8
Custom Short Field
 
x(20)
 
 
CustomShort9
Custom Short Field
 
x(20)
 
 
KPI_ID
Link to KPI
 
-99999999999
 
 
KPISlice_ID
Link to KPISlice
 
-99999999999
 
 
KPISliceLink_ID
Record ID
 
-99999999999
 
 
LastModifiedDate
Last Modified Date
Mod Date
99/99/9999
 
 
LastModifiedTime
Last Modified Time
Mod Time
99999
 
 
LastModifiedUser
Last Modified User
Mod User
x(20)
 
 
QADC01
 
 
x(40)
 
 
QADC02
 
 
x(255)
 
 
QADD01
 
 
->,>>>,>>9.9999
10
 
QADT01
 
 
99/99/9999
 
 
 
 
Index-Name
Uni
Field-Name
Asc
Abbr
 
KPIIdx
no
KPI_ID
yes
no
 ∗
Prim
yes
KPISliceLink_ID
yes
no
 
SliceIdx
no
KPISlice_ID
yes
no
 
UniqIdx
yes
KPI_ID
yes
no
 
 
 
KPISlice_ID
yes
no
kstc_det
Ending Inventory Balance by Site
 
 
Field Name
Label
Col-Label
Format
Dec
 
kstc__qadc01
QAD Character Field 1
 
x(24)
 
 
kstc__qadc02
QAD Character Field 2
 
x(24)
 
 
kstc__qadd01
QAD Decimal Field 1
 
->>>,>>>,>>9.99<<
10
 
kstc__qadt01
QAD Date Field 1
 
99/99/99
 
 
kstc_domain
Domain
 
x(8)
 
 
kstc_end_bal
Ending Inventory Quantity
End Inv Qty
->>,>>>,>>9.9<<<<<<<<<
10
 
kstc_end_cst
Ending Cost
 
>>>>,>>>,>>9.99<<<
10
 
kstc_mod_date
Modified Date
Mod Date
99/99/99
 
 
kstc_mod_userid
User ID
 
x(8)
 
 
kstc_month
Month
 
>9
 
 
kstc_part
Item Number
 
x(18)
 
 
kstc_period
Period
 
99/9999
 
 
kstc_site
Site
 
x(8)
 
 
kstc_user1
User Field Character 1
 
x(24)
 
 
kstc_user2
User Field Character 2
 
x(24)
 
 
kstc_year
Year
 
9999
 
 
oid_kstc_det
 
 
>>>>>>>>>>>>>>>>>>>>>>>>>>>9.9<<<<<<<<<
10
 
 
 
Index-Name
Uni
Field-Name
Asc
Abbr
kstc_det
yes
kstc_domain
yes
no
 
 
 
kstc_site
yes
no
 
 
 
kstc_part
yes
no
 
 
 
kstc_year
yes
no
 
 
 
kstc_month
yes
no
 
kstc_part
no
kstc_domain
yes
no
 
 
 
kstc_part
yes
no
 
 
 
kstc_site
yes
no
 
kstc_year_per
no
kstc_domain
yes
no
 
 
 
kstc_year
yes
no
 
 
 
kstc_month
yes
no
 
 
 
kstc_part
yes
no
 
 
 
kstc_site
yes
no
 
oid_kstc_det
yes
oid_kstc_det
yes
no
LabourC
Warehousing Labour Management Control
 
 
Field Name
Label
Col-Label
Format
Dec
 
Active
Active
Act
yes/no
 
 
CheckCalendar
Check User/Group Calendars
 
yes/no
 
 
CheckIntRouting
Include Routing Tasks
 
yes/no
 
 
CheckTaskAssignment
Check User Task Assignment
 
yes/no
 
 
CheckTravelSequence
Check User Travel Sequence
 
yes/no
 
 
CreateDate
Create Date
 
99/99/99
 
 
CreateUserID
Created
 
x(8)
 
 
DisplayMaxMinutes
Display Tasks for Next
 
>>>>>>9
 
 
DisplayMaxTasks
Display Next
 
>>>>>>9
 
 
Domain
Domain
 
x(8)
 
 
ModDate
Modified
 
99/99/99
 
 
ModUserID
Modified
 
x(8)
 
 
oid_LabourC
 
 
>>>>>>>>>>>>>>>>>>>>>>>>>>>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
 
 
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_LabourC
yes
oid_LabourC
yes
no
 ∗
UniqueID
yes
Domain
yes
no
 
 
 
UniqueID
yes
no
 
UsrIdx
no
Domain
yes
no
 
 
 
User1
yes
no
 
 
 
User2
yes
no
lacd_det
Logistics Accounting Charge Detail
 
 
Field Name
Label
Col-Label
Format
Dec
 
lacd__qadc01
 
 
x(24)
 
 
lacd__qadc02
 
 
x(24)
 
 
lacd_accrual_level
Accrual Level
Accrual!Level
x(2)
 
 
lacd_apportion_method
Apportion Method
App Method
x(2)
 
 
lacd_charge
LC Charge
LC Chg
->>,>>>,>>9.9<<<
10
 
lacd_curr
Currency
Curr
x(3)
 
 
lacd_disc_pct
Disc %
 
->>9.99%
10
 
lacd_domain
Domain
 
x(8)
 
 
lacd_element
Cost Element
 
x(8)
 
 
lacd_ex_rate
Exch Rate
 
>>>>,>>>,>>9.9<<<<<<<<<
10
 
lacd_ex_rate2
Exch Rate 2
 
>>>>,>>>,>>9.9<<<<<<<<<
10
 
lacd_fix_rate
Fixed Rate
Fixed
yes/no
 
 
lacd_fixed
Fixed Rate
Fixed
yes/no
 
 
lacd_internal_ref
Internal Reference
 
x(20)
 
 
lacd_internal_ref_type
Internal Reference Type
Internal!Ref Type
x(2)
 
 
lacd_lc_amt
Amount
 
->>>>,>>>,>>9.9<<<<<<
10
 
lacd_lc_charge
Logistics Charge Code
Chrg Code
x(8)
 
 
lacd_list
Logistic Charge List
LC List
x(8)
 
 
lacd_log_supplier
Supplier
 
x(8)
 
 
lacd_mgmt_ex_rate
Exchange Rate
Exch Rate
>>>>,>>>,>>9.9<<<<<<<<<
10
 
lacd_mgmt_ex_rate2
Management Curr Exchange Rate
Mgmt Curr!Exch Rate
>>>>,>>>,>>9.9<<<<<<<<<
10
 
lacd_mod_date
Modified Date
Mod Date
99/99/99
 
 
lacd_mod_userid
User ID
 
x(8)
 
 
lacd_shipfrom
Ship-From
 
x(8)
 
 
lacd_type
Type
 
x(8)
 
 
lacd_um
UM
 
x(2)
 
 
lacd_user1
User Field Character 1
 
x(24)
 
 
lacd_user2
User Field Character 2
 
x(24)
 
 
oid_lacd_det
 
 
>>>>>>>>>>>>>>>>>>>>>>>>>>>9.9<<<<<<<<<
10
 
 
 
Index-Name
Uni
Field-Name
Asc
Abbr
lacd_internal_ref
yes
lacd_domain
yes
no
 
 
 
lacd_internal_ref
yes
no
 
 
 
lacd_shipfrom
yes
no
 
 
 
lacd_lc_charge
yes
no
 
 
 
lacd_internal_ref_type
yes
no
 
oid_lacd_det
yes
oid_lacd_det
yes
no
lacod_det
Logistic Accounting Charge Detail by Order Line
 
 
Field Name
Label
Col-Label
Format
Dec
 
lacod__qadc01
 
 
x(24)
 
 
lacod__qadc02
QAD Character Field 2
 
x(24)
 
 
lacod_apportion_rate
Apportion Rate
App Rate
>>9.9<<
10
 
lacod_curr
Currency
Curr
x(3)
 
 
lacod_ex_rate
Exch Rate
 
>>>>,>>>,>>9.9<<<<<<<<<
10
 
lacod_ex_rate2
Exch Rate 2
 
>>>>,>>>,>>9.9<<<<<<<<<
10
 
lacod_lc_amt
Amount
 
->>>>,>>>,>>9.9<<<<<<
10
 
lacod_mgmt_ex_rate
Exchange Rate
Exch Rate
>>>>,>>>,>>9.9<<<<<<<<<
10
 
lacod_mgmt_ex_rate2
Management Curr Exchange Rate
Mgmt Curr!Exch Rate
>>>>,>>>,>>9.9<<<<<<<<<
10
 
lacod_mod_date
Modified Date
Mod Date
99/99/99
 
 
lacod_mod_userid
User ID
 
x(8)
 
 
lacod_user1
User Field Character 1
 
x(24)
 
 
lacod_user2
User Field Character 2
 
x(24)
 
 
oid_lacd_det
 
 
>>>>>>>>>>>>>>>>>>>>>>>>>>>9.9<<<<<<<<<
10
 
oid_lacod_det
 
 
>>>>>>>>>>>>>>>>>>>>>>>>>>>9.9<<<<<<<<<
10
 
oid_lgd_mstr
 
 
>>>>>>>>>>>>>>>>>>>>>>>>>>>9.9<<<<<<<<<
10
 
oid_order_line
 
 
>>>>>>>>>>>>>>>>>>>>>>>>>>>9.9<<<<<<<<<
10
 
 
 
Index-Name
Uni
Field-Name
Asc
Abbr
lacod_oid_lacd_det
yes
oid_lacd_det
yes
no
 
 
 
oid_order_line
yes
no
 
lacod_oid_ord_line
yes
oid_order_line
yes
no
 
 
 
oid_lacd_det
yes
no
 
oid_lacod_det
yes
oid_lacod_det
yes
no
 
oid_lgd_mstr
no
oid_lgd_mstr
yes
no
lac_ctrl
Logistics Accounting Control
 
 
Field Name
Label
Col-Label
Format
Dec
 
lac__qadc01
 
 
x(24)
 
 
lac__qadc02
 
 
x(24)
 
 
lac__qadi01
 
 
->>>>>>>9
 
 
lac_base_ship_um
Base Ship UM
UM
x(2)
 
 
lac_base_vol_um
Base Vol UM
UM
x(2)
 
 
lac_blank_suppliers
Match Blank Suppliers
 
yes/no
 
 
lac_domain
Domain
 
x(8)
 
 
lac_doship_nrm_id
Distribution Order Shipment Sequence ID
 
x(8)
 
 
lac_mod_date
Modified Date
Mod Date
99/99/99
 
 
lac_mod_userid
User ID
 
x(8)
 
 
lac_soship_nrm_id
Sales Order Shipment Sequence ID
 
x(8)
 
 
lac_use_logistics
Use Logistics Accounting
 
yes/no
 
 
lac_user1
User Field Character 1
 
x(24)
 
 
lac_user2
User Field Character 2
 
x(24)
 
 
oid_lac_ctrl
 
 
>>>>>>>>>>>>>>>>>>>>>>>>>>>9.9<<<<<<<<<
10
 
 
 
Index-Name
Uni
Field-Name
Asc
Abbr
lac_index1
yes
lac_domain
yes
no
 
oid_lac_ctrl
yes
oid_lac_ctrl
yes
no
lad_det
Location Allocation Detail
 
 
Field Name
Label
Col-Label
Format
Dec
 
lad__qadc01
 
 
x(8)
 
 
lad_act_pick
Actual Picked
 
->>,>>>,>>9.9<<<<<<<<<
10
 
lad_cont_qty
Container Quantity
 
->>,>>>,>>9.9<<<<<<<<<
10
 
lad_dataset
Data Set
 
x(12)
 
 
lad_domain
Domain
 
x(8)
 
 
lad_line
Line/ID
 
x(8)
 
 
lad_loc
Location
 
x(8)
 
 
lad_lot
Lot/Serial
 
x(18)
 
 
lad_nbr
Order
Order Number
x(18)
 
 
lad_ord_site
Order Site
Ord Site
x(8)
 
 
lad_part
Item Number
 
x(18)
 
 
lad_qty_all
Qty Allocated
Qty Alloc
->>>,>>9.9<<<<<<
10
 
lad_qty_chg
Qty to Iss
 
->>>,>>9.9<<<<<<
10
 
lad_qty_pick
Qty Picked
 
->>>,>>9.9<<<<<<
10
 
lad_ref
Ref
Reference
x(8)
 
 
lad_site
Site
 
x(8)
 
 
lad_user1
Ufld1
 
x(8)
 
 
lad_user2
Ufld2
 
x(8)
 
 
oid_lad_det
 
 
>>>>>>>>>>>>>>>>>>>>>>>>>>>9.9<<<<<<<<<
10
 
 
 
Index-Name
Uni
Field-Name
Asc
Abbr
lad_det
yes
lad_domain
yes
no
 
 
 
lad_dataset
yes
no
 
 
 
lad_nbr
yes
no
 
 
 
lad_line
yes
no
 
 
 
lad_part
yes
no
 
 
 
lad_site
yes
no
 
 
 
lad_loc
yes
no
 
 
 
lad_lot
yes
no
 
 
 
lad_ref
yes
no
 
lad_site
no
lad_domain
yes
no
 
 
 
lad_site
yes
no
 
 
 
lad_loc
yes
no
 
 
 
lad_part
yes
no
 
 
 
lad_lot
yes
no
 
 
 
lad_ref
yes
no
 
oid_lad_det
yes
oid_lad_det
yes
no
LaneAssD
Warehousing Lane Assignment Detail
 
 
Field Name
Label
Col-Label
Format
Dec
 
CreateDate
Create Date
 
99/99/99
 
 
CreateUserID
Created
 
x(8)
 
 
Domain
Domain
 
x(8)
 
 
LaneGroup
Lane Group
Group
x(8)
 
 
ModDate
Modified Date
Mod Date
99/99/99
 
 
ModUserID
User ID
 
x(8)
 
 
oid_LaneAssD
 
 
>>>>>>>>>>>>>>>>>>>>>>>>>>>9.9<<<<<<<<<
10
 
PartType
Warehouse Item Type
Warehouse!Item Type
x(8)
 
 
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
 
 
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
 
 
Whse
Warehouse
Whse
x(8)
 
 
 
 
Index-Name
Uni
Field-Name
Asc
Abbr
 
oid_LaneAssD
yes
oid_LaneAssD
yes
no
 ∗
SiteWhsePart
yes
Domain
yes
no
 
 
 
Site
yes
no
 
 
 
Whse
yes
no
 
 
 
PartType
yes
no
 
 
 
LaneGroup
yes
no
 
UsrIdx
no
Domain
yes
no
 
 
 
User1
yes
no
 
 
 
User2
yes
no
LaneAssM
Warehousing Lane Assignment Master
 
 
Field Name
Label
Col-Label
Format
Dec
 
CreateDate
Create Date
 
99/99/99
 
 
CreateUserID
Created
 
x(8)
 
 
Description
Description
 
x(24)
 
 
Domain
Domain
 
x(8)
 
 
LastLaneGroup
Last Lane Group
Last
x(8)
 
 
ModDate
Modified Date
Mod Date
99/99/99
 
 
ModUserID
User ID
 
x(8)
 
 
oid_LaneAssM
 
 
>>>>>>>>>>>>>>>>>>>>>>>>>>>9.9<<<<<<<<<
10
 
PartType
Warehouse Item Type
Warehouse!Item Type
x(8)
 
 
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
 
 
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
 
 
Whse
Warehouse
Whse
x(8)
 
 
 
 
Index-Name
Uni
Field-Name
Asc
Abbr
 
oid_LaneAssM
yes
oid_LaneAssM
yes
no
 
PartSiteWhse
yes
Domain
yes
no
 
 
 
PartType
yes
no
 
 
 
Site
yes
no
 
 
 
Whse
yes
no
 ∗
SiteWhsePart
yes
Domain
yes
no
 
 
 
Site
yes
no
 
 
 
Whse
yes
no
 
 
 
PartType
yes
no
 
UserIdx
no
Domain
yes
no
 
 
 
User1
yes
no
 
 
 
User2
yes
no
LaneGroupD
Warehousing Lane Group Detail
 
 
Field Name
Label
Col-Label
Format
Dec
 
Active
Active
Act
yes/no
 
 
CreateDate
Create Date
 
99/99/99
 
 
CreateUserID
Created
 
x(8)
 
 
Domain
Domain
 
x(8)
 
 
Lane
Lane
 
x(8)
 
 
LaneGroup
Lane Group
Group
x(8)
 
 
ModDate
Modified
 
99/99/99
 
 
ModUserID
Modified
 
x(8)
 
 
oid_LaneGroupD
 
 
>>>>>>>>>>>>>>>>>>>>>>>>>>>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
 
 
Seq
Sequence
Seq
>>>9
 
 
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
 
 
Whse
Warehouse
Whse
x(8)
 
 
 
 
Index-Name
Uni
Field-Name
Asc
Abbr
 ∗
LaneGroup
yes
Domain
yes
no
 
 
 
Site
yes
no
 
 
 
Whse
yes
no
 
 
 
LaneGroup
yes
no
 
 
 
Seq
yes
no
 
 
 
Lane
yes
no
 
oid_LaneGroupD
yes
oid_LaneGroupD
yes
no
 
SiteWhseLane
no
Domain
yes
no
 
 
 
Site
yes
no
 
 
 
Whse
yes
no
 
 
 
Lane
yes
no
 
UsrIdx
no
Domain
yes
no
 
 
 
User1
yes
no
 
 
 
User2
yes
no
LaneGroupM
Warehousing Lane Group Master
 
 
Field Name
Label
Col-Label
Format
Dec
 
CreateDate
Create Date
 
99/99/99
 
 
CreateUserID
Created
 
x(8)
 
 
Description
Description
Desc
x(24)
 
 
Domain
Domain
 
x(8)
 
 
LaneGroup
Lane Group
Group
x(8)
 
 
ModDate
Modified
 
99/99/99
 
 
ModUserID
Modified
 
x(8)
 
 
oid_LaneGroupM
 
 
>>>>>>>>>>>>>>>>>>>>>>>>>>>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
 
 
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
 
 
Whse
Warehouse
Whse
x(8)
 
 
 
 
Index-Name
Uni
Field-Name
Asc
Abbr
 ∗
LaneGroup
yes
Domain
yes
no
 
 
 
Site
yes
no
 
 
 
Whse
yes
no
 
 
 
LaneGroup
yes
no
 
oid_LaneGroupM
yes
oid_LaneGroupM
yes
no
 
UsrIdx
no
Domain
yes
no
 
 
 
User1
yes
no
 
 
 
User2
yes
no
LaneM
Warehousing Lane Master
 
 
Field Name
Label
Col-Label
Format
Dec
 
Capacity
Capacity
Cap
->>,>>9.99
2
 
CapUM
UM
UM
x(2)
 
 
Carrier
Carrier
 
x(8)
 
 
CreateDate
Create Date
 
99/99/99
 
 
CreateUserID
Created
 
x(8)
 
 
Description
Description
Desc
x(24)
 
 
Dock
Dock
 
x(8)
 
 
Domain
Domain
 
x(8)
 
 
Lane
Lane
 
x(8)
 
 
ModDate
Modified Date
Mod Date
99/99/99
 
 
ModUserID
User ID
 
x(8)
 
 
oid_LaneM
 
 
>>>>>>>>>>>>>>>>>>>>>>>>>>>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
 
 
Site
Site
 
x(8)
 
 
Tasks
Number of Open Tasks
Open Tasks
->,>>>,>>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
 
 
Whse
Warehouse
Whse
x(8)
 
 
 
 
Index-Name
Uni
Field-Name
Asc
Abbr
 
oid_LaneM
yes
oid_LaneM
yes
no
 ∗
SiteWhseLane
yes
Domain
yes
no
 
 
 
Site
yes
no
 
 
 
Whse
yes
no
 
 
 
Lane
yes
no
 
UsrIdx
no
Domain
yes
no
 
 
 
User1
yes
no
 
 
 
User2
yes
no
Layer
Layer
 
 
Field Name
Label
Col-Label
Format
Dec
 
CustomCombo0
Custom Combo Field
 
x(20)
 
 
CustomCombo1
Custom Combo Field
 
x(20)
 
 
CustomCombo2
Custom Combo Field
 
x(20)
 
 
CustomCombo3
Custom Combo Field
 
x(20)
 
 
CustomCombo4
Custom Combo Field
 
x(20)
 
 
CustomCombo5
Custom Combo Field
 
x(20)
 
 
CustomCombo6
Custom Combo Field
 
x(20)
 
 
CustomCombo7
Custom Combo Field
 
x(20)
 
 
CustomCombo8
Custom Combo Field
 
x(20)
 
 
CustomCombo9
Custom Combo Field
 
x(20)
 
 
CustomDate0
Custom Date Field
 
99/99/9999
 
 
CustomDate1
Custom Date Field
 
99/99/9999
 
 
CustomDate2
Custom Date Field
 
99/99/9999
 
 
CustomDate3
Custom Date Field
 
99/99/9999
 
 
CustomDate4
Custom Date Field
 
99/99/9999
 
 
CustomDecimal0
Custom Decimal Field
 
->,>>>,>>9.99
4
 
CustomDecimal1
Custom Decimal Field
 
->,>>>,>>9.99
4
 
CustomDecimal2
Custom Decimal Field
 
->,>>>,>>9.99
4
 
CustomDecimal3
Custom Decimal Field
 
->,>>>,>>9.99
4
 
CustomDecimal4
Custom Decimal Field
 
->,>>>,>>9.99
4
 
CustomInteger0
Custom Integer Field
 
->,>>>,>>9
 
 
CustomInteger1
Custom Integer Field
 
->,>>>,>>9
 
 
CustomInteger2
Custom Integer Field
 
->,>>>,>>9
 
 
CustomInteger3
Custom Integer Field
 
->,>>>,>>9
 
 
CustomInteger4
Custom Integer Field
 
->,>>>,>>9
 
 
CustomLong0
Custom Long Field
 
x(255)
 
 
CustomLong1
Custom Long Field
 
x(255)
 
 
CustomNote
Custom Note Field
 
x(2000)
 
 
CustomShort0
Custom Short Field
 
x(20)
 
 
CustomShort1
Custom Short Field
 
x(20)
 
 
CustomShort2
Custom Short Field
 
x(20)
 
 
CustomShort3
Custom Short Field
 
x(20)
 
 
CustomShort4
Custom Short Field
 
x(20)
 
 
CustomShort5
Custom Short Field
 
x(20)
 
 
CustomShort6
Custom Short Field
 
x(20)
 
 
CustomShort7
Custom Short Field
 
x(20)
 
 
CustomShort8
Custom Short Field
 
x(20)
 
 
CustomShort9
Custom Short Field
 
x(20)
 
 
LastModifiedDate
Last Modified Date
Mod Date
99/99/9999
 
 
LastModifiedTime
Last Modified Time
Mod Time
99999
 
 
LastModifiedUser
Last Modified User
Mod User
x(20)
 
 
Layer_ID
Record ID
 
-99999999999
 
 
LayerCode
Layer Code
 
x(20)
 
 
LayerDescription
Description
 
x(40)
 
 
LayerIsActive
Active
Act
yes/no
 
 
LayerIsAddGLLnNbrIN
Additional GL Line Numbering (IN)
 
yes/no
 
 
LayerIsAddGLNbr
Use Additional GL Numbering
Additional GL Numbering
yes/no
 
 
LayerTypeCode
Layer Type
Type
x(20)
 
 
QADC01
 
 
x(40)
 
 
QADC02
 
 
x(255)
 
 
QADD01
 
 
->,>>>,>>9.9999
10
 
QADT01
 
 
99/99/9999
 
 
 
 
Index-Name
Uni
Field-Name
Asc
Abbr
 
Code
yes
LayerCode
yes
no
 
LastModIdx
no
LastModifiedDate
yes
no
 ∗
Prim
yes
Layer_ID
yes
no
 
Type
no
LayerTypeCode
yes
no
 
ViewIndex
no
LayerIsActive
yes
no
 
 
 
LayerCode
yes
no
lblc_ctrl
Label Control
 
 
Field Name
Label
Col-Label
Format
Dec
 
lblc__qadc01
 
 
x(8)
 
 
lblc__qadc02
 
 
x(8)
 
 
lblc__qadl01
 
 
yes/no
 
 
lblc__qadl02
 
 
yes/no
 
 
lblc_index1
Index
 
>>>>>>9
 
 
lblc_mod_date
Modified date
Mod Date
99/99/99
 
 
lblc_mod_userid
User ID
 
x(8)
 
 
lblc_trans_frame
Translate Frames
 
yes/no
 
 
lblc_user1
Ufld1
 
x(8)
 
 
lblc_user2
Ufld2
 
x(8)
 
 
oid_lblc_ctrl
 
 
>>>>>>>>>>>>>>>>>>>>>>>>>>>9.9<<<<<<<<<
10
 
 
 
Index-Name
Uni
Field-Name
Asc
Abbr
lblc_index1
yes
lblc_index1
yes
no
 
oid_lblc_ctrl
yes
oid_lblc_ctrl
yes
no
lcpr_mstr
Logistics Charge Price List
 
 
Field Name
Label
Col-Label
Format
Dec
 
lcpr__qadc01
 
 
x(24)
 
 
lcpr__qadc02
 
 
x(24)
 
 
lcpr__qadd01
 
 
->>>>>>>>>>>>>>>>>>>>>>>>>>>9.9<<<<<<<<<
10
 
lcpr_charge
Charge
 
->>,>>>,>>9.9<<<
10
 
lcpr_curr
Currency
Cur
x(3)
 
 
lcpr_domain
Domain
 
x(8)
 
 
lcpr_end
End
 
99/99/99
 
 
lcpr_lc_charge
Logistic Charge Code
Chrg Code
x(8)
 
 
lcpr_list
Logistic Charge List
LC List
x(8)
 
 
lcpr_log_supplier
Logistic Supplier
Log Supp
x(8)
 
 
lcpr_mod_date
Modified Date
Mod Date
99/99/99
 
 
lcpr_mod_userid
User ID
 
x(8)
 
 
lcpr_start
Start
 
99/99/99
 
 
lcpr_trade_class
Trade Class
 
x(8)
 
 
lcpr_trade_env
Trade Environment
Trade Env
x(18)
 
 
lcpr_um
Unit of Measure
UM
x(2)
 
 
lcpr_user1
User Field Character 1
 
x(24)
 
 
lcpr_user2
User Field Character 2
 
x(24)
 
 
oid_lcpr_mstr
 
 
>>>>>>>>>>>>>>>>>>>>>>>>>>>9.9<<<<<<<<<
10
 
 
 
Index-Name
Uni
Field-Name
Asc
Abbr
 
lcpr_lc_charge
no
lcpr_domain
yes
no
 
 
 
lcpr_lc_charge
yes
no
 
 
 
lcpr_log_supplier
yes
no
 
 
 
lcpr_trade_env
yes
no
 
 
 
lcpr_trade_class
yes
no
 
 
 
lcpr_curr
yes
no
 
 
 
lcpr_um
yes
no
 
 
 
lcpr_start
yes
no
lcpr_list
yes
lcpr_domain
yes
no
 
 
 
lcpr_list
yes
no
 
 
 
lcpr_lc_charge
yes
no
 
 
 
lcpr_log_supplier
yes
no
 
 
 
lcpr_trade_env
yes
no
 
 
 
lcpr_trade_class
yes
no
 
 
 
lcpr_curr
yes
no
 
 
 
lcpr_um
yes
no
 
 
 
lcpr_start
yes
no
 
oid_lcpr_mstr
yes
oid_lcpr_mstr
yes
no
lctxd_det
Logistic Charge Tax Detail
 
 
Field Name
Label
Col-Label
Format
Dec
 
lctxd__qadc01
 
 
x(24)
 
 
lctxd__qadc02
 
 
x(24)
 
 
lctxd__qadd01
 
 
->>>>,>>>,>>9.9<<<<<<<<<
10
 
lctxd__qadt01
 
 
99/99/99
 
 
lctxd_charge
Logistics Charge Code
 
x(8)
 
 
lctxd_domain
Domain
 
x(8)
 
 
lctxd_mod_date
Last Modified Date
Mod Date
99/99/99
 
 
lctxd_mod_userid
Last Modified User Id
 
x(8)
 
 
lctxd_tax_type
Tax Type
 
x(16)
 
 
lctxd_taxable
Taxable
 
Yes/No
 
 
lctxd_taxc
Tax Class
 
x(3)
 
 
lctxd_user1
User Field Character 1
 
x(24)
 
 
lctxd_user2
User Field Character 2
 
x(24)
 
 
oid_lctxd_det
Unique application generated record identifier.
 
>>>>>>>>>>>>>>>>>>>>>>>>>>>9.9<<<<<<<<<
10
 
 
 
Index-Name
Uni
Field-Name
Asc
Abbr
lctxd_charge_tax
yes
lctxd_domain
yes
no
 
 
 
lctxd_charge
yes
no
 
 
 
lctxd_tax_type
yes
no
 
oid_lctxd_det
yes
oid_lctxd_det
yes
no
lc_mstr
Logistics Accounting Charge Code Master
 
 
Field Name
Label
Col-Label
Format
Dec
 
lc__qadc01
 
 
x(24)
 
 
lc__qadc02
 
 
x(24)
 
 
lc_apportion_method
Apportion Method
 
x(2)
 
 
lc_charge
Logistics Charge Code
Chrg Code
x(8)
 
 
lc_close_accruals
Close Accruals On First Voucher
Close Accruals
yes/no
 
 
lc_desc
Description
 
x(24)
 
 
lc_domain
Domain
 
x(8)
 
 
lc_element
Cost Element
 
x(8)
 
 
lc_mod_date
Modified Date
Mod Date
99/99/99
 
 
lc_mod_userid
User ID
 
x(8)
 
 
lc_supplier
Supplier
 
x(8)
 
 
lc_taxable
Taxable
 
yes/no
 
 
lc_taxc
Tax Class
TxC
x(3)
 
 
lc_trade_class
Trade Class
 
x(8)
 
 
lc_type
Type
 
x(8)
 
 
lc_um
UM
 
x(2)
 
 
lc_user1
User Field Character 1
 
x(24)
 
 
lc_user2
User Field Character 2
 
x(24)
 
 
oid_lc_mstr
 
 
>>>>>>>>>>>>>>>>>>>>>>>>>>>9.9<<<<<<<<<
10
 
 
 
Index-Name
Uni
Field-Name
Asc
Abbr
lc_charge
yes
lc_domain
yes
no
 
 
 
lc_charge
yes
no
 
lc_element
no
lc_domain
yes
no
 
 
 
lc_element
yes
no
 
 
 
lc_charge
yes
no
 
oid_lc_mstr
yes
oid_lc_mstr
yes
no
ld_det
Location Detail
 
 
Field Name
Label
Col-Label
Format
Dec
 
ld__chr01
 
 
x(8)
 
 
ld__chr02
 
 
x(8)
 
 
ld__chr03
 
 
x(8)
 
 
ld__chr04
 
 
x(8)
 
 
ld__chr05
 
 
x(8)
 
 
ld__dec01
 
 
>>>,>>>,>>9.99
10
 
ld__dec02
 
 
>>>,>>>,>>9.99
10
 
ld__dte01
 
 
99/99/99
 
 
ld__dte02
 
 
99/99/99
 
 
ld__log01
 
 
yes/no
 
 
ld_alt_um
Alternate UM
UM
x(2)
 
 
ld_assay
Assay %
 
>>9.99%
10
 
ld_cmtindx
Comment Index
Comment
>>>>>>>9
 
 
ld_cnt_date
Last Count
Last Cnt
99/99/99
 
 
ld_cost
 
 
>>>>,>>>,>>9.99<<<
10
 
ld_crt_date
Create Date
 
99/99/99
 
 
ld_crt_time
Create Time
Time
>>>>>>>9
 
 
ld_cust_consign_qty
Customer Consignment Qty
Customer!Consignment
->>,>>>,>>9.9<<<<<<<<<
10
 
ld_date
Date Created
Created
99/99/99
 
 
ld_date_frz
Freeze Date
Frz Date
99/99/99
 
 
ld_domain
Domain
 
x(8)
 
 
ld_exp_qtyin
Qty In
In
->>,>>>,>>9.9<<<<<<<<<
10
 
ld_exp_qtyout
Qty Out
Out
->>,>>>,>>9.9<<<<<<<<<
10
 
ld_expire
Expire Date
Expire
99/99/99
 
 
ld_grade
Grade
 
x(2)
 
 
ld_loc
Location
 
x(8)
 
 
ld_lot
Lot/Serial
 
x(18)
 
 
ld_part
Item Number
 
x(18)
 
 
ld_qty_all
Qty Allocated
 
->,>>>,>>9.9<<<<<<<<
10
 
ld_qty_frz
Freeze Qty
 
->,>>>,>>9.9<<<<<<<<
10
 
ld_qty_oh
Qty On Hand
 
->,>>>,>>9.9<<<<<<<<
10
 
ld_ref
Ref
Reference
x(8)
 
 
ld_rev
Rev
 
x(4)
 
 
ld_site
Site
 
x(8)
 
 
ld_status
Inventory Status
Status
x(8)
 
 
ld_supp_consign_qty
Supplier Consignment Qty
Supplier!Consignment
->>,>>>,>>9.9<<<<<<<<<
10
 
ld_time_frz
Freeze Time
Frz Time
>>,>>9
 
 
ld_user1
Ufld1
 
x(8)
 
 
ld_user2
Ufld2
 
x(8)
 
 
ld_vd_lot
Not Used
 
x(18)
 
 
ld_work
 
 
->>>,>>>,>>9.9<<<<<<<<<
10
 
oid_ld_det
 
 
>>>>>>>>>>>>>>>>>>>>>>>>>>>9.9<<<<<<<<<
10
 
 
 
Index-Name
Uni
Field-Name
Asc
Abbr
ld_loc_p_lot
yes
ld_domain
yes
no
 
 
 
ld_site
yes
no
 
 
 
ld_loc
yes
no
 
 
 
ld_part
yes
no
 
 
 
ld_lot
yes
no
 
 
 
ld_ref
yes
no
 
ld_part_loc
yes
ld_domain
yes
no
 
 
 
ld_part
yes
no
 
 
 
ld_site
yes
no
 
 
 
ld_loc
yes
no
 
 
 
ld_lot
yes
no
 
 
 
ld_ref
yes
no
 
ld_part_lot
yes
ld_domain
yes
no
 
 
 
ld_part
yes
no
 
 
 
ld_lot
yes
no
 
 
 
ld_ref
yes
no
 
 
 
ld_site
yes
no
 
 
 
ld_loc
yes
no
 
ld_serial
no
ld_domain
yes
no
 
 
 
ld_ref
yes
no
 
 
 
ld_part
yes
no
 
 
 
ld_site
yes
no
 
ld_status
yes
ld_domain
yes
no
 
 
 
ld_status
yes
no
 
 
 
ld_part
yes
no
 
 
 
ld_site
yes
no
 
 
 
ld_loc
yes
no
 
 
 
ld_lot
yes
no
 
 
 
ld_ref
yes
no
 
oid_ld_det
yes
oid_ld_det
yes
no
lgdc_ctrl
Legal Document Control
 
 
Field Name
Label
Col-Label
Format
Dec
 
lgdc__qadc01
QAD Character Field 1
 
x(24)
 
 
lgdc__qadc02
QAD Character Field 2
 
x(24)
 
 
lgdc__qadd01
QAD Decimal Field 1
 
->>>,>>>,>>9.99<<
10
 
lgdc__qadi01
 
 
->>>>>>>9
 
 
lgdc__qadi02
 
 
->>>>>>>9
 
 
lgdc__qadt01
QAD Date Field 1
 
99/99/99
 
 
lgdc_apply_disc
Legal Doc Discount
 
Yes/No
 
 
lgdc_consol_lines
Legal Doc Line Consol
 
Yes/No
 
 
lgdc_custom
PO Shipper/Invoice
 
x(14)
 
 
lgdc_days_cancel_lgd
Days to Cancel a Legal Document
 
>>9
 
 
lgdc_domain
Domain
 
x(8)
 
 
lgdc_eff_date
Update Effective Date
 
yes/no
 
 
lgdc_elec
Enable Electronic Legal Doc
 
yes/no
 
 
lgdc_email
Send Email
 
yes/no
 
 
lgdc_fiscal_ctrl
Enable Fiscal Control
 
yes/no
 
 
lgdc_form_code
Legal Document Form Code
 
x(2)
 
 
lgdc_inconsist
PO with Inconsistencies
 
yes/no
 
 
lgdc_maint_type
Op Type in Tax Usage
 
yes/no
 
 
lgdc_mod_date
Modified Date
Mod Date
99/99/99
 
 
lgdc_mod_userid
User ID
 
x(8)
 
 
lgdc_next_batch_id
Next NFe Batch ID
 
>>>>>>>>>>>>>>9
0
 
lgdc_nrm_multi
Allow Same NRM for Multiple Addresses
 
yes/no
 
 
lgdc_phy_receipt
Physical Receipt
 
x(14)
 
 
lgdc_po_cancel
PO Cancel Program
 
x(14)
 
 
lgdc_prec_amt
Precision
 
.99
10
 
lgdc_print
Document Printing
 
yes/no
 
 
lgdc_qty_pct
Percent on Quantity Counted
 
>>>>.99
10
 
lgdc_sim_id
Simulation ID
 
x(8)
 
 
lgdc_summ_ld_lines
Summarize Legal Doc lines
 
yes/no
 
 
lgdc_type
Type
 
x(8)
 
 
lgdc_user1
User Field Character 1
 
x(24)
 
 
lgdc_user2
User Field Character 2
 
x(24)
 
 
oid_lgdc_ctrl
 
 
>>>>>>>>>>>>>>>>>>>>>>>>>>>9.9<<<<<<<<<
10
 
 
 
Index-Name
Uni
Field-Name
Asc
Abbr
lgdc_index1
yes
lgdc_domain
yes
no
 
oid_lgdc_ctrl
yes
oid_lgdc_ctrl
yes
no
lgddl_det
This is a link table between two legal document detail
 
 
Field Name
Label
Col-Label
Format
Dec
 
lgddl__qadc01
 
 
x(24)
 
 
lgddl__qadc02
 
 
x(24)
 
 
lgddl_mod_date
Last Modified Date
Mod Date
99/99/99
 
 
lgddl_mod_userid
Last Modified User Id
 
x(8)
 
 
lgddl_prim_effdate
Orig Effective Date
Orig Eff Date
99/99/99
 
 
lgddl_prim_nbr
Orig Doc
 
x(12)
 
 
lgddl_prim_nfe_key_nbr
Access Key Number
Acc Key
x(44)
 
 
lgddl_prim_shipfrom
Orig Ship From
 
x(8)
 
 
lgddl_qty_item
Qty Allocated
Allocated
->,>>>,>>9.9<<<
10
 
lgddl_user1
User Field Character 1
 
x(24)
 
 
lgddl_user2
User Field Character 2
 
x(24)
 
 
oid_lgdd_det
 
 
>>>>>>>>>>>>>>>>>>>>>>>>>>>9.9<<<<<<<<<
10
 
oid_lgdd_det_prim
 
 
>>>>>>>>>>>>>>>>>>>>>>>>>>>9.9<<<<<<<<<
10
 
oid_lgddl_det
 
 
>>>>>>>>>>>>>>>>>>>>>>>>>>>9.9<<<<<<<<<
10
 
 
 
Index-Name
Uni
Field-Name
Asc
Abbr
 
lgddl_nbr
no
lgddl_prim_nbr
yes
no
 
 
 
lgddl_prim_shipfrom
yes
no
 
 
 
lgddl_prim_effdate
yes
no
 
lgddl_oid_lgdd_det
no
oid_lgdd_det
yes
no
 
lgddl_prim
no
oid_lgdd_det_prim
yes
no
oid_lgddl_det
yes
oid_lgddl_det
yes
no
lgdd_det
Legal Document Detail Table
 
 
Field Name
Label
Col-Label
Format
Dec
 
lgdd__qadc01
QAD Character Field 1
 
x(24)
 
 
lgdd__qadc02
QAD Character Field 2
 
x(24)
 
 
lgdd__qadd01
QAD Decimal Field 1
 
->>>,>>>,>>9.99<<
10
 
lgdd__qadt01
QAD Date Field 1
 
99/99/99
 
 
lgdd_acct
Account
Acct
x(8)
 
 
lgdd_addr
Legal Doc Addr
 
x(8)
 
 
lgdd_alt_um
Alternate UM
 
x(2)
 
 
lgdd_cc
Cost Center
CC
x(4)
 
 
lgdd_cfop_code
CFOP
 
x(20)
 
 
lgdd_cmtindx
Comment Index
Comment
>>>>>>>9
 
 
lgdd_desc
Description
 
x(48)
 
 
lgdd_doc_type
Doc Type
 
x(2)
 
 
lgdd_domain
Domain
 
x(8)
 
 
lgdd_dsc_amt
Discount Amount
 
->>>>,>>>,>>9.99<
10
 
lgdd_ex_code
EX Code
 
x(8)
 
 
lgdd_expire
Expire Date
 
99/99/99
 
 
lgdd_ext_price
Ext Price
 
->>>>,>>>,>>9.99<
10
 
lgdd_fiscal_type
Fiscal Type
 
x(2)
 
 
lgdd_gl_ref
GL References
 
x(14)
 
 
lgdd_gwt
Gross Weight
Gross Wt
>,>>>,>>9.9<<<<<<<<
10
 
lgdd_ipi_cst
IPI CST
 
x(8)
 
 
lgdd_item_num
Item Number
 
x(30)
 
 
lgdd_legal_class
Legal Classification
Legal Class
x(18)
 
 
lgdd_line
Line
Ln
>>9
 
 
lgdd_loc
Location
 
x(8)
 
 
lgdd_lotser
Lot/Serial
 
x(18)
 
 
lgdd_mod_date
Modified Date
Mod Date
99/99/99
 
 
lgdd_mod_userid
User ID
 
x(8)
 
 
lgdd_nbr
Legal Doc Nbr
Legal Doc
x(12)
 
 
lgdd_nfc_st
Status
 
yes/no
 
 
lgdd_nwt
Net Weight
 
>,>>>,>>9.9<<<<<<<<
10
 
lgdd_order
Order
 
x(8)
 
 
lgdd_order_line
Line
Ln
>>9
 
 
lgdd_origin
Origin Code
 
x(8)
 
 
lgdd_part
Item Number
 
x(18)
 
 
lgdd_phy_mov
Physical Move
 
x(1)
 
 
lgdd_pm_code
Pur/Mfg
P/M
x(1)
 
 
lgdd_price
Price
 
>>>>,>>>,>>9.99<<<
10
 
lgdd_prim_addr
Orig Addr
 
x(8)
 
 
lgdd_prim_doc_type
Orig Doc Type
 
x(2)
 
 
lgdd_prim_nbr
Orig Doc
 
x(12)
 
 
lgdd_project
Project
 
x(8)
 
 
lgdd_ps_qty
Packing Slip Qty
 
->,>>>,>>9.9<<<<<<<<
10
 
lgdd_qty_item
Item Quantity
Item Qty
->,>>>,>>9.9<<<
10
 
lgdd_ref
Ref
 
x(8)
 
 
lgdd_ret_nbr
Ret Nbr
 
x(20)
 
 
lgdd_service_code
Service Code
 
x(8)
 
 
lgdd_sh_cmtindx
Shipper Comment Index
Ship Comm Ind
>>>>>>>9
 
 
lgdd_shipfrom
Ship From
 
x(8)
 
 
lgdd_shipper_id
Shipper ID
 
x(20)
 
 
lgdd_sub
Sub-Account
Sub-Acct
x(8)
 
 
lgdd_tax_env
Tax Environment
Tax Env
x(16)
 
 
lgdd_tax_in
Tax In
 
yes/no
 
 
lgdd_tax_usage
Tax Usage
TaxUsage
x(8)
 
 
lgdd_taxable
Taxable
Tax
yes/no
 
 
lgdd_taxc
Tax Class
TxC
x(3)
 
 
lgdd_trib_sit
Tax SIT Code
 
x(3)
 
 
lgdd_type
Ship Type
T
x(1)
 
 
lgdd_um
UM
 
x(2)
 
 
lgdd_um_conv
UM Conversion
UM Conv
>>>>9.9999<<<<
10
 
lgdd_user1
User Field Character 1
 
x(24)
 
 
lgdd_user2
User Field Character 2
 
x(24)
 
 
lgdd_wt_um
Weight UM
 
x(2)
 
 
oid_abs_mstr
Unique application generated record identifier.
 
>>>>>>>>>>>>>>>>>>>>>>>>>>>9.9<<<<<<<<<
10
 
oid_lgd_mstr
 
 
>>>>>>>>>>>>>>>>>>>>>>>>>>>9.9<<<<<<<<<
10
 
oid_lgdd_det
 
 
>>>>>>>>>>>>>>>>>>>>>>>>>>>9.9<<<<<<<<<
10
 
 
 
Index-Name
Uni
Field-Name
Asc
Abbr
 
lgdd_nbr
no
lgdd_domain
yes
no
 
 
 
lgdd_nbr
yes
no
 
 
 
lgdd_order
yes
no
 
lgdd_oid_lgd_mstr
no
oid_lgd_mstr
yes
no
lgdd_shipper
no
lgdd_domain
yes
no
 
 
 
lgdd_shipper_id
yes
no
 
 
 
lgdd_line
yes
no
 
 
 
lgdd_nbr
yes
no
 
lgdd_tax_usage
no
lgdd_domain
yes
no
 
 
 
lgdd_tax_usage
yes
no
 
oid_lgdd_det
yes
oid_lgdd_det
yes
no
lgdfcb_det
Legal Document Fiscal Control Balance Detail
 
 
Field Name
Label
Col-Label
Format
Dec
 
lgdfcb__qadc01
 
 
x(24)
 
 
lgdfcb__qadc02
 
 
x(24)
 
 
lgdfcb_date
Date
 
99/99/99
 
 
lgdfcb_domain
Domain
 
x(8)
 
 
lgdfcb_id
Fiscal Control ID
Fiscal ID
x(8)
 
 
lgdfcb_key
Control Key
Key
x(30)
 
 
lgdfcb_mod_date
Modified Date
Mod Date
99/99/99
 
 
lgdfcb_mod_userid
User ID
 
x(8)
 
 
lgdfcb_move_code
Move Code
 
x(2)
 
 
lgdfcb_move_init
Move Initiated
Init
x(2)
 
 
lgdfcb_rmks
Remarks
 
x(40)
 
 
lgdfcb_rsn_code
Reason
 
x(8)
 
 
lgdfcb_status
Status
St
x(2)
 
 
lgdfcb_time
Time
 
>>,>>>,>>9
 
 
lgdfcb_user1
User Field Character 1
 
x(24)
 
 
lgdfcb_user2
User Field Character 2
 
x(24)
 
 
oid_lgdd_det
 
 
>>>>>>>>>>>>>>>>>>>>>>>>>>>9.9<<<<<<<<<
10
 
oid_lgdfcb_det
 
 
>>>>>>>>>>>>>>>>>>>>>>>>>>>9.9<<<<<<<<<
10
 
 
 
Index-Name
Uni
Field-Name
Asc
Abbr
 
lgdfcb_lgdd
no
lgdfcb_domain
yes
no
 
 
 
lgdfcb_id
yes
no
 
 
 
oid_lgdd_det
yes
no
 
lgdfcb_move_code
no
lgdfcb_domain
yes
no
 
 
 
lgdfcb_move_code
yes
no
 
 
 
lgdfcb_id
yes
no
 
 
 
lgdfcb_key
yes
no
 
 
 
lgdfcb_date
yes
no
oid_lgdfcb_det
yes
oid_lgdfcb_det
yes
no
lgdfcd_det
Fiscal Control Definition Detail
 
 
Field Name
Label
Col-Label
Format
Dec
 
lgdfcd__qadc01
 
 
x(8)
 
 
lgdfcd__qadc02
 
 
x(8)
 
 
lgdfcd__qadd01
 
 
->>>>,>>>,>>9.9<<<<<<<<<
10
 
lgdfcd__qadl01
 
 
yes/no
 
 
lgdfcd__qadt01
 
 
99/99/99
 
 
lgdfcd_active
Active
 
yes/no
 
 
lgdfcd_domain
Domain
 
x(8)
 
 
lgdfcd_id
Fiscal Control ID
Fiscal ID
x(8)
 
 
lgdfcd_key
Control Key
Key
x(30)
 
 
lgdfcd_mod_date
Last Modified Date
Mod Date
99/99/99
 
 
lgdfcd_mod_userid
Last Modified User Id
 
x(8)
 
 
lgdfcd_op
Operation
 
x(2)
 
 
lgdfcd_sel_prim
Select Original
 
x(2)
 
 
lgdfcd_user1
User Field Character 1
 
x(8)
 
 
lgdfcd_user2
User Field Character 2
 
x(8)
 
 
lgdfcd_userc03
User Field Character 3
 
x(24)
 
 
lgdfcd_userc04
User Field Character 4
 
x(24)
 
 
lgdfcd_userd01
User Field Decimal 1
 
->>>>,>>>,>>9.9<<<<<<<<<
10
 
lgdfcd_userd02
User Field Decimal 2
 
->>>>,>>>,>>9.9<<<<<<<<<
10
 
lgdfcd_userl01
User Field Logical 1
 
yes/no
 
 
lgdfcd_usert01
User Field Date 1
 
99/99/99
 
 
oid_lgdfcd_det
 
 
>>>>>>>>>>>>>>>>>>>>>>>>>>>9.9<<<<<<<<<
10
 
 
 
Index-Name
Uni
Field-Name
Asc
Abbr
lgdfcd_id_key
yes
lgdfcd_domain
yes
no
 
 
 
lgdfcd_id
yes
no
 
 
 
lgdfcd_key
yes
no
 
lgdfcd_key
no
lgdfcd_domain
yes
no
 
 
 
lgdfcd_key
yes
no
 
oid_lgdfcd_det
yes
oid_lgdfcd_det
yes
no