|
|
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
|
|
|
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
|
|
|
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
|
|
|
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
|
|
|
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
|
|
|
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
|
|
|
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
|
|
|
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
|
|
|
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
|
|
|
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
|
|
|
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
|
|
|
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
|
|
|
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
|
|
|
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
|
|
|
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
|
|
|
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
|
|
|
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
|
|
|
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
|
|
|
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
|
|
|
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
|
|
|
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
|
|
|
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
|
|
|
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
|
|
|
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
|