|
|
Field Name
|
Label
|
Col-Label
|
Format
|
Dec
|
|
|
oid_tblc_mstr
|
|
|
>>>>>>>>>>>>>>>>>>>>>>>>>>>9.9<<<<<<<<<
|
10
|
|
|
tblc__qadc01
|
|
|
X(24)
|
|
|
|
tblc__qadc02
|
|
|
X(24)
|
|
|
|
tblc_active
|
Active
|
|
yes/no
|
|
|
|
tblc_delete
|
Delete
|
|
yes/no
|
|
|
|
tblc_desc
|
Description
|
|
x(24)
|
|
|
|
tblc_domain
|
Domain
|
|
x(8)
|
|
|
|
tblc_mod_date
|
Modified Date
|
Mod Date
|
99/99/99
|
|
|
|
tblc_mod_userid
|
User ID
|
|
X(24)
|
|
|
|
tblc_table
|
Table
|
|
x(16)
|
|
|
|
tblc_user1
|
User Field Character 1
|
|
X(24)
|
|
|
|
tblc_user2
|
User Field Character 2
|
|
X(24)
|
|
|
|
Index-Name
|
Uni
|
Field-Name
|
Asc
|
Abbr
|
|
|
oid_tblc_mstr
|
yes
|
oid_tblc_mstr
|
yes
|
no
|
|
∗
|
tblc_table
|
yes
|
tblc_domain
|
yes
|
no
|
|
|
|
|
tblc_table
|
yes
|
no
|
|
|
Field Name
|
Label
|
Col-Label
|
Format
|
Dec
|
|
|
oid_tbl_mstr
|
|
|
>>>>>>>>>>>>>>>>>>>>>>>>>>>9.9<<<<<<<<<
|
10
|
|
|
tbl__chr01
|
User Character Field 1
|
|
x(8)
|
|
|
|
tbl__chr02
|
User Character Field 2
|
|
x(8)
|
|
|
|
tbl__chr03
|
User Character Field 3
|
|
x(8)
|
|
|
|
tbl__chr04
|
User Character Field 4
|
|
x(8)
|
|
|
|
tbl__chr05
|
User Character Field 5
|
|
x(8)
|
|
|
|
tbl__dec01
|
User Decimal Field 1
|
|
->>,>>9.99
|
10
|
|
|
tbl__dec02
|
User Decimal Field 2
|
|
->>,>>9.99
|
10
|
|
|
tbl__dte01
|
User Date Field 1
|
|
99/99/99
|
|
|
|
tbl__dte02
|
User Date Field 2
|
|
99/99/99
|
|
|
|
tbl__log01
|
User Logical Field 1
|
|
yes/no
|
|
|
|
tbl__log02
|
User Logical Field 2
|
|
yes/no
|
|
|
|
tbl__qadc01
|
QAD Character Field 1
|
|
x(8)
|
|
|
|
tbl__qadc02
|
QAD Character Field 2
|
|
x(8)
|
|
|
|
tbl__qadd01
|
QAD Date Field 1
|
|
99/99/99
|
|
|
|
tbl__qadd02
|
QAD Date Field 2
|
|
99/99/99
|
|
|
|
tbl__qadde01
|
QAD Decimal Field 1
|
|
->>,>>9.99
|
10
|
|
|
tbl__qadde02
|
QAD Decimal Field 2
|
|
->>,>>9.99
|
10
|
|
|
tbl__qadl01
|
QAD Logical Field 1
|
|
yes/no
|
|
|
|
tbl__qadl02
|
QAD Logical Field 2
|
|
yes/no
|
|
|
|
tbl_compcode
|
Component
|
|
x(18)
|
|
|
|
tbl_comptype
|
Component Type
|
Comp Type
|
x(12)
|
|
|
|
tbl_domain
|
Domain
|
|
x(8)
|
|
|
|
tbl_end
|
End Effective
|
End Eff
|
99/99/99
|
|
|
|
tbl_mod_date
|
Modified Date
|
Mod Date
|
99/99/99
|
|
|
|
tbl_mod_userid
|
User ID
|
|
X(8)
|
|
|
|
tbl_parcode
|
Parent
|
|
x(18)
|
|
|
|
tbl_partype
|
Parent Type
|
|
x(12)
|
|
|
|
tbl_ref
|
Reference
|
|
x(12)
|
|
|
|
tbl_rmks
|
Remarks
|
|
x(24)
|
|
|
|
tbl_start
|
Start Effective
|
Start Eff
|
99/99/99
|
|
|
|
tbl_user1
|
Ufld1
|
|
x(8)
|
|
|
|
tbl_user2
|
Ufld2
|
|
x(8)
|
|
|
|
Index-Name
|
Uni
|
Field-Name
|
Asc
|
Abbr
|
|
|
oid_tbl_mstr
|
yes
|
oid_tbl_mstr
|
yes
|
no
|
|
|
tbl_comp
|
no
|
tbl_domain
|
yes
|
no
|
|
|
|
|
tbl_comptype
|
yes
|
no
|
|
|
|
|
tbl_compcode
|
yes
|
no
|
|
∗
|
tbl_typecode
|
yes
|
tbl_domain
|
yes
|
no
|
|
|
|
|
tbl_partype
|
yes
|
no
|
|
|
|
|
tbl_parcode
|
yes
|
no
|
|
|
|
|
tbl_comptype
|
yes
|
no
|
|
|
|
|
tbl_compcode
|
yes
|
no
|
|
|
Field Name
|
Label
|
Col-Label
|
Format
|
Dec
|
|
|
oid_tbtx_mstr
|
Unique application generated record identifier.
|
|
>>>>>>>>>>>>>>>>>>>>>>>>>>>9.9<<<<<<<<<
|
10
|
|
|
tbtx__qadc01
|
|
|
x(24)
|
|
|
|
tbtx__qadc02
|
|
|
x(24)
|
|
|
|
tbtx__qadd01
|
|
|
->>>>,>>>,>>9.9<<<<<<<<<
|
10
|
|
|
tbtx__qadt01
|
|
|
99/99/99
|
|
|
|
tbtx_domain
|
Domain
|
|
x(8)
|
|
|
|
tbtx_entity
|
Entity code
|
|
x(20)
|
|
|
|
tbtx_mod_date
|
Last Modified Date
|
|
99/99/99
|
|
|
|
tbtx_mod_userid
|
Last Modified User Id
|
|
x(8)
|
|
|
|
tbtx_period
|
GL Period
|
|
99
|
|
|
|
tbtx_tax_amt
|
Tax Balance Amount
|
|
->,>>>,>>>,>>9.99
|
10
|
|
|
tbtx_tax_box_code
|
Tax box code
|
|
x(20)
|
|
|
|
tbtx_user1
|
User Field Character 1
|
|
x(24)
|
|
|
|
tbtx_user2
|
User Field Character 2
|
|
x(24)
|
|
|
|
tbtx_year
|
GL Year
|
|
9999
|
|
|
|
Index-Name
|
Uni
|
Field-Name
|
Asc
|
Abbr
|
|
|
oid_tbtx_mstr
|
yes
|
oid_tbtx_mstr
|
yes
|
no
|
|
∗
|
tbtx_tax_box
|
yes
|
tbtx_domain
|
yes
|
no
|
|
|
|
|
tbtx_entity
|
yes
|
no
|
|
|
|
|
tbtx_year
|
yes
|
no
|
|
|
|
|
tbtx_period
|
yes
|
no
|
|
|
|
|
tbtx_tax_box_code
|
yes
|
no
|
|
|
Field Name
|
Label
|
Col-Label
|
Format
|
Dec
|
|
|
CreateDate
|
Create Date
|
|
99/99/99
|
|
|
|
CreateUserID
|
Created
|
|
x(8)
|
|
|
|
Domain
|
Domain
|
|
x(8)
|
|
|
|
Language
|
Language
|
Lang
|
x(2)
|
|
|
|
ModDate
|
Modified Date
|
Mod Date
|
99/99/99
|
|
|
|
ModUserID
|
User ID
|
|
x(8)
|
|
|
|
oid_TemplateD
|
|
|
>>>>>>>>>>>>>>>>>>>>>>>>>>>9.9<<<<<<<<<
|
10
|
|
|
PrinterType
|
Printer Type
|
Printer!Type
|
X(8)
|
|
|
|
PrintFlavor
|
Print Flavor
|
Prt!Flv
|
x(1)
|
|
|
|
PrintLine
|
Print Line
|
|
x(132)
|
|
|
|
PrintProcCode
|
Print Procedure Code
|
Print!Proc
|
x(2)
|
|
|
|
PrintSeq
|
Seq
|
|
>>>9
|
|
|
|
QadC01
|
QAD Field
|
|
X(8)
|
0
|
|
|
QadC02
|
QAD Field
|
|
X(8)
|
0
|
|
|
QadC03
|
QAD Field
|
|
X(8)
|
0
|
|
|
QadC04
|
QAD Field
|
|
X(8)
|
0
|
|
|
QadC05
|
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
|
|
|
UserI01
|
User Field Integer 1
|
|
->>>>>>>9
|
|
|
|
UserI02
|
User Field Integer 2
|
|
->>>>>>>9
|
|
|
|
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 1
|
|
99/99/99
|
|
|
|
Index-Name
|
Uni
|
Field-Name
|
Asc
|
Abbr
|
|
|
oid_TemplateD
|
yes
|
oid_TemplateD
|
yes
|
no
|
|
∗
|
TempSeq
|
yes
|
Domain
|
yes
|
no
|
|
|
|
|
Language
|
yes
|
no
|
|
|
|
|
PrinterType
|
yes
|
no
|
|
|
|
|
PrintProcCode
|
yes
|
no
|
|
|
|
|
PrintFlavor
|
yes
|
no
|
|
|
|
|
PrintSeq
|
yes
|
no
|
|
|
UsrIdx
|
no
|
Domain
|
yes
|
no
|
|
|
|
|
User1
|
yes
|
no
|
|
|
|
|
User2
|
yes
|
no
|
|
|
Field Name
|
Label
|
Col-Label
|
Format
|
Dec
|
|
|
CmtIndx
|
Comments
|
|
>>>>>>>9
|
|
|
|
CreateDate
|
Create Date
|
|
99/99/99
|
|
|
|
CreateUserID
|
Created
|
|
x(8)
|
|
|
|
Description
|
Description
|
|
x(24)
|
|
|
|
Domain
|
Domain
|
|
x(8)
|
|
|
|
Language
|
Language
|
Lang
|
x(2)
|
|
|
|
ModDate
|
Modified
|
|
99/99/99
|
|
|
|
ModUserID
|
Modified
|
|
x(8)
|
|
|
|
oid_TemplateM
|
|
|
>>>>>>>>>>>>>>>>>>>>>>>>>>>9.9<<<<<<<<<
|
10
|
|
|
OrigFile
|
File
|
|
x(72)
|
|
|
|
PrinterType
|
Printer Type
|
Printer!Type
|
X(8)
|
|
|
|
PrintFlavor
|
Print Flavor
|
Prt!Flv
|
x(1)
|
|
|
|
PrintProcCode
|
Print Procedure Code
|
Print!Proc
|
x(2)
|
|
|
|
QadC01
|
QAD Field
|
|
X(8)
|
0
|
|
|
QadC02
|
QAD Field
|
|
X(8)
|
0
|
|
|
QadC03
|
QAD Field
|
|
X(8)
|
0
|
|
|
QadC04
|
QAD Field
|
|
X(8)
|
0
|
|
|
QadC05
|
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
|
|
|
UserI01
|
User Field Integer 1
|
|
->>>>>>>9
|
|
|
|
UserI02
|
User Field Integer 2
|
|
->>>>>>>9
|
|
|
|
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 1
|
|
99/99/99
|
|
|
|
Index-Name
|
Uni
|
Field-Name
|
Asc
|
Abbr
|
|
|
oid_TemplateM
|
yes
|
oid_TemplateM
|
yes
|
no
|
|
∗
|
Tempidx
|
yes
|
Domain
|
yes
|
no
|
|
|
|
|
Language
|
yes
|
no
|
|
|
|
|
PrinterType
|
yes
|
no
|
|
|
|
|
PrintProcCode
|
yes
|
no
|
|
|
|
|
PrintFlavor
|
yes
|
no
|
|
|
UsrIdx
|
no
|
Domain
|
yes
|
no
|
|
|
|
|
User1
|
yes
|
no
|
|
|
|
|
User2
|
yes
|
no
|
|
|
Field Name
|
Label
|
Col-Label
|
Format
|
Dec
|
|
|
oid_te_mstr
|
|
|
>>>>>>>>>>>>>>>>>>>>>>>>>>>9.9<<<<<<<<<
|
10
|
|
|
te__chr01
|
|
|
X(8)
|
|
|
|
te__chr02
|
|
|
X(8)
|
|
|
|
te__dec01
|
|
|
999999999.99
|
10
|
|
|
te__dec02
|
|
|
999999999.99
|
10
|
|
|
te__dte01
|
|
|
99/99/99
|
|
|
|
te__dte02
|
|
|
99/99/99
|
|
|
|
te__log01
|
|
|
yes/no
|
|
|
|
te__log02
|
|
|
yes/no
|
|
|
|
te__qadc01
|
|
|
X(8)
|
|
|
|
te__qadc02
|
|
|
X(8)
|
|
|
|
te__qadc03
|
|
|
X(8)
|
|
|
|
te__qadc04
|
|
|
X(8)
|
|
|
|
te__qadd07
|
|
|
999999999.99
|
10
|
|
|
te__qadd08
|
|
|
999999999.99
|
10
|
|
|
te__qadi05
|
|
|
9999
|
|
|
|
te__qadi06
|
|
|
9999
|
|
|
|
te__qadl11
|
|
|
YES/NO
|
|
|
|
te__qadl12
|
|
|
YES/NO
|
|
|
|
te__qadt09
|
|
|
99/99/99
|
|
|
|
te__qadt10
|
|
|
99/99/99
|
|
|
|
te_data
|
DATA
|
|
X(255)
|
|
|
|
te_date
|
Date Created
|
|
99/99/99
|
|
|
|
te_date_deliv
|
Date Delivered
|
|
99/99/99
|
|
|
|
te_date_exp
|
Date Exported
|
|
99/99/99
|
|
|
|
te_dest
|
Dest ID
|
|
x(16)
|
|
|
|
te_domain
|
Domain
|
|
x(8)
|
|
|
|
te_exp_type
|
Export Type
|
|
x(16)
|
|
|
|
te_line
|
Line
|
|
9999
|
|
|
|
te_nbr
|
Number
|
|
99999999
|
|
|
|
te_pgm
|
Program
|
|
x(16)
|
|
|
|
te_pgm_errs
|
Error Count
|
|
9999
|
|
|
|
te_pgm_msgs[10]
|
Errors
|
|
x(40)
|
|
|
|
te_pgm_warn
|
Warn Count
|
|
9999
|
|
|
|
te_site
|
Site
|
|
x(8)
|
|
|
|
te_time
|
Time Created
|
|
x(8)
|
|
|
|
te_time_deliv
|
Time Delivered
|
|
x(8)
|
|
|
|
te_time_exp
|
Time Exported
|
|
x(8)
|
|
|
|
te_updt
|
Update Type
|
|
x(3)
|
|
|
|
te_user1
|
Ufld1
|
|
X(8)
|
|
|
|
te_user2
|
Ufld2
|
|
X(8)
|
|
|
|
te_userid
|
User ID
|
|
x(8)
|
|
|
|
Index-Name
|
Uni
|
Field-Name
|
Asc
|
Abbr
|
|
|
oid_te_mstr
|
yes
|
oid_te_mstr
|
yes
|
no
|
|
|
te_date
|
no
|
te_domain
|
yes
|
no
|
|
|
|
|
te_date
|
yes
|
no
|
|
|
te_date_deliv
|
no
|
te_domain
|
yes
|
no
|
|
|
|
|
te_date_deliv
|
yes
|
no
|
|
|
te_dest
|
no
|
te_domain
|
yes
|
no
|
|
|
|
|
te_dest
|
yes
|
no
|
|
|
te_exp_type
|
no
|
te_domain
|
yes
|
no
|
|
|
|
|
te_exp_type
|
yes
|
no
|
|
∗
|
te_mstr
|
yes
|
te_domain
|
yes
|
no
|
|
|
|
|
te_site
|
yes
|
no
|
|
|
|
|
te_nbr
|
yes
|
no
|
|
|
|
|
te_line
|
yes
|
no
|
|
|
te_nbr
|
yes
|
te_domain
|
yes
|
no
|
|
|
|
|
te_nbr
|
yes
|
no
|
|
|
|
|
te_line
|
yes
|
no
|
|
|
Field Name
|
Label
|
Col-Label
|
Format
|
Dec
|
|
|
oid_tm_mstr
|
|
|
>>>>>>>>>>>>>>>>>>>>>>>>>>>9.9<<<<<<<<<
|
10
|
|
|
tm__qadc01
|
|
|
x(8)
|
|
|
|
tm_cmtindx
|
Comment Index
|
Comment
|
>>>>>>>9
|
|
|
|
tm_code
|
Transport ID
|
Trans ID
|
x(8)
|
|
|
|
tm_cube_um
|
UM
|
|
x(2)
|
|
|
|
tm_desc
|
Description
|
|
x(24)
|
|
|
|
tm_domain
|
Domain
|
|
x(8)
|
|
|
|
tm_gross_wt
|
Gross Vehicle Weight
|
GVW
|
->>,>>>,>>9.9<<<
|
10
|
|
|
tm_height
|
Height
|
|
>>>,>>>,>>9.9<<<
|
10
|
|
|
tm_length
|
Length
|
|
>>>,>>>,>>9.9<<<
|
10
|
|
|
tm_load_lt
|
Load LT
|
|
->>9.9<
|
10
|
|
|
tm_maxcube
|
Max Load Volume
|
Max Vol
|
>>>,>>>,>>9.9<<<
|
10
|
|
|
tm_maxweight
|
Max Load Weight
|
Max Load
|
>>>,>>>,>>9.9<<<
|
10
|
|
|
tm_no_units
|
Available Units
|
Units
|
->,>>>,>>9
|
|
|
|
tm_pallet_floor_locations
|
Pallet Floor Locations
|
|
>>9
|
|
|
|
tm_pallets
|
Pallet Capacity
|
Pallets
|
>>>,>>>,>>9
|
|
|
|
tm_rate_code
|
Rate Table
|
Rate
|
x(8)
|
|
|
|
tm_stack_level
|
Stacking Level
|
|
>>9
|
|
|
|
tm_type
|
Transport Type
|
Type
|
x(8)
|
|
|
|
tm_unload_lt
|
Unload LT
|
|
->>9.9<
|
10
|
|
|
tm_user1
|
Ufld1
|
|
x(8)
|
|
|
|
tm_user2
|
Ufld2
|
|
x(8)
|
|
|
|
tm_weight_um
|
UM
|
|
x(2)
|
|
|
|
tm_width
|
Width
|
|
>>>,>>>,>>9.9<<<
|
10
|
|
|
Index-Name
|
Uni
|
Field-Name
|
Asc
|
Abbr
|
|
|
oid_tm_mstr
|
yes
|
oid_tm_mstr
|
yes
|
no
|
|
∗
|
tm_code
|
yes
|
tm_domain
|
yes
|
no
|
|
|
|
|
tm_code
|
yes
|
no
|
|
|
tm_desc
|
no
|
tm_domain
|
yes
|
no
|
|
|
|
|
tm_desc
|
yes
|
no
|
|
|
|
|
tm_code
|
yes
|
no
|
|
|
tm_rate
|
no
|
tm_domain
|
yes
|
no
|
|
|
|
|
tm_rate_code
|
yes
|
no
|
|
|
|
|
tm_code
|
yes
|
no
|
|
|
Field Name
|
Label
|
Col-Label
|
Format
|
Dec
|
|
|
oid_totd_det
|
|
|
>>>>>>>>>>>>>>>>>>>>>>>>>>>9.9<<<<<<<<<
|
10
|
|
|
totd__qadc01
|
|
|
x(24)
|
|
|
|
totd__qadc02
|
|
|
x(24)
|
|
|
|
totd_domain
|
Domain
|
|
x(8)
|
|
|
|
totd_lc_charge
|
Logistics Charge Code
|
Chrg Code
|
x(8)
|
|
|
|
totd_mod_date
|
Modified Date
|
Mod Date
|
99/99/99
|
|
|
|
totd_mod_userid
|
User ID
|
|
x(8)
|
|
|
|
totd_responsibility
|
Responsibility
|
|
x(2)
|
|
|
|
totd_terms_code
|
Terms of Trade
|
|
x(8)
|
|
|
|
totd_user1
|
User Field Character 1
|
|
x(24)
|
|
|
|
totd_user2
|
User Field Character 2
|
|
x(24)
|
|
|
|
Index-Name
|
Uni
|
Field-Name
|
Asc
|
Abbr
|
|
|
oid_totd_det
|
yes
|
oid_totd_det
|
yes
|
no
|
|
∗
|
totd_terms_code
|
yes
|
totd_domain
|
yes
|
no
|
|
|
|
|
totd_terms_code
|
yes
|
no
|
|
|
|
|
totd_lc_charge
|
yes
|
no
|
|
|
Field Name
|
Label
|
Col-Label
|
Format
|
Dec
|
|
|
oid_tot_mstr
|
|
|
>>>>>>>>>>>>>>>>>>>>>>>>>>>9.9<<<<<<<<<
|
10
|
|
|
tot__qadc01
|
|
|
x(24)
|
|
|
|
tot__qadc02
|
|
|
x(24)
|
|
|
|
tot_domain
|
Domain
|
|
x(8)
|
|
|
|
tot_mod_date
|
Modified Date
|
Mod Date
|
99/99/99
|
|
|
|
tot_mod_userid
|
User ID
|
|
x(8)
|
|
|
|
tot_terms_code
|
Terms of Trade
|
|
x(8)
|
|
|
|
tot_terms_desc
|
Description
|
|
x(24)
|
|
|
|
tot_transport_resp
|
Transportation Responsibility
|
|
x(2)
|
|
|
|
tot_user1
|
User Field Character 1
|
|
x(24)
|
|
|
|
tot_user2
|
User Field Character 2
|
|
x(24)
|
|
|
|
Index-Name
|
Uni
|
Field-Name
|
Asc
|
Abbr
|
|
|
oid_tot_mstr
|
yes
|
oid_tot_mstr
|
yes
|
no
|
|
∗
|
tot_terms_code
|
yes
|
tot_domain
|
yes
|
no
|
|
|
|
|
tot_terms_code
|
yes
|
no
|
|
|
Field Name
|
Label
|
Col-Label
|
Format
|
Dec
|
|
|
ABSID
|
ABS ID
|
|
x(8)
|
|
|
|
ContainerID
|
Container ID
|
|
x(8)
|
|
|
|
CreateDate
|
Create Date
|
|
99/99/99
|
|
|
|
CreateUserID
|
Created
|
|
x(8)
|
|
|
|
Domain
|
Domain
|
|
x(8)
|
|
|
|
MasterTrackingNbr
|
Master Tracking Nbr
|
|
x(35)
|
|
|
|
ModDate
|
Modified
|
|
99/99/99
|
|
|
|
ModUserID
|
Modified
|
|
x(8)
|
|
|
|
oid_TrackingD
|
|
|
>>>>>>>>>>>>>>>>>>>>>>>>>>>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
|
|
|
|
ShipVia
|
Ship Via
|
|
x(20)
|
|
|
|
Site
|
Site
|
|
x(8)
|
|
|
|
TrackingNumber
|
Tracking Number
|
|
x(35)
|
|
|
|
TrackingURL
|
Carrier URL
|
|
x(65)
|
|
|
|
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
|
|
|
|
Whse
|
Warehouse
|
Whse
|
x(8)
|
|
|
|
Index-Name
|
Uni
|
Field-Name
|
Asc
|
Abbr
|
|
∗
|
ABSID
|
yes
|
Domain
|
yes
|
no
|
|
|
|
|
Site
|
yes
|
no
|
|
|
|
|
ABSID
|
yes
|
no
|
|
|
|
|
ContainerID
|
yes
|
no
|
|
|
MasterTrackingNbr
|
no
|
Domain
|
yes
|
no
|
|
|
|
|
MasterTrackingNbr
|
yes
|
no
|
|
|
|
|
ShipVia
|
yes
|
no
|
|
|
oid_TrackingD
|
yes
|
oid_TrackingD
|
yes
|
no
|
|
|
SiteWhse
|
no
|
Domain
|
yes
|
no
|
|
|
|
|
Site
|
yes
|
no
|
|
|
|
|
Whse
|
yes
|
no
|
|
|
TrackingNumber
|
no
|
Domain
|
yes
|
no
|
|
|
|
|
TrackingNumber
|
yes
|
no
|
|
|
|
|
ShipVia
|
yes
|
no
|
|
|
UsrIdx
|
no
|
Domain
|
yes
|
no
|
|
|
|
|
UserC01
|
yes
|
no
|
|
|
|
|
UserC02
|
yes
|
no
|
|
|
Field Name
|
Label
|
Col-Label
|
Format
|
Dec
|
|
|
ABSID
|
ABS ID
|
|
x(8)
|
|
|
|
ABSShipFrom
|
Ship From
|
|
x(8)
|
|
|
|
Addr
|
Address
|
|
x(8)
|
|
|
|
AlgoNbr
|
Algorithm
|
Algo
|
>>9
|
|
|
|
AlgoType
|
Type
|
|
X(2)
|
|
|
|
AverageTime
|
Time
|
|
->>,>>9.99
|
10
|
|
|
BulkPick
|
Bulk Pick
|
Bulk!Pick
|
x(8)
|
|
|
|
CloseDate
|
Closed
|
|
99/99/99
|
|
|
|
CloseProgname
|
Closed
|
|
x(10)
|
|
|
|
CloseTime
|
Close Time
|
|
->,>>>,>>9
|
|
|
|
CloseUserID
|
Closed
|
|
x(8)
|
|
|
|
CmtIndx
|
Comments
|
|
>>>>>>>9
|
|
|
|
CompDate
|
Completed Date
|
|
99/99/99
|
|
|
|
CompTime
|
|
|
->,>>>,>>9
|
|
|
|
CreateDate
|
Create Date
|
|
99/99/99
|
|
|
|
CreateProgName
|
Created ProgName
|
|
x(10)
|
|
|
|
CreateTime
|
Created Time
|
|
->,>>>,>>9
|
|
|
|
CreateUserID
|
Created UserID
|
|
x(8)
|
|
|
|
CurrUserID
|
Current
|
|
x(8)
|
|
|
|
Domain
|
Domain
|
|
x(8)
|
|
|
|
ExistSample
|
Exist Sample
|
|
yes/no
|
|
|
|
Fail
|
Fail
|
|
yes/no
|
|
|
|
FromAltUM
|
From UM
|
Fr!UM
|
x(2)
|
|
|
|
FromDigit
|
From Digit
|
From!Digit
|
x(8)
|
|
|
|
FromLoc
|
From Location
|
From!Location
|
x(8)
|
|
|
|
FromLot
|
From Lot/Serial
|
|
x(18)
|
|
|
|
FromPart
|
From Item Number
|
|
x(18)
|
|
|
|
FromRef
|
From Reference
|
From!Reference
|
x(8)
|
|
|
|
FromSite
|
From Site
|
From!Site
|
x(8)
|
|
|
|
FromSlocgp
|
From SLocGrp
|
From!SLocGrp
|
x(8)
|
|
|
|
FromWhse
|
From Whse
|
From!Whse
|
x(8)
|
|
|
|
FromWlocgp
|
From WLocGrp
|
From!WLocGrp
|
x(8)
|
|
|
|
HardAssign
|
Hard Assignment
|
Hard
|
yes/no
|
|
|
|
IntRouteCode
|
Internal Routing
|
Internal!Routing
|
x(8)
|
|
|
|
IntRouteSeq
|
Seq
|
|
>>9
|
|
|
|
InventNbr
|
Internal Inventory ID
|
Internal!Invent ID
|
99999999
|
|
|
|
IssDSet
|
Issue Data Set
|
|
x(12)
|
|
|
|
IssLine
|
Issue Line/ID
|
Issue!Line/ID
|
x(8)
|
|
|
|
IssNbr
|
Issue Order
|
|
x(18)
|
|
|
|
IssTrNbr
|
Issue
|
|
>>>>>>>>>9
|
|
|
|
KeepFromStatus
|
Keep From Status
|
Keep!From!Status
|
yes/no
|
|
|
|
ModDate
|
Modified
|
|
99/99/99
|
|
|
|
ModeM
|
Mode
|
|
X(8)
|
|
|
|
ModUserID
|
Modified
|
|
x(8)
|
|
|
|
NumTasks
|
Num Tasks
|
|
->>,>>9.99
|
10
|
|
|
oid_TranD
|
|
|
>>>>>>>>>>>>>>>>>>>>>>>>>>>9.9<<<<<<<<<
|
10
|
|
|
OrigFrLoc
|
Original From Location
|
Original!From Loc
|
x(8)
|
|
|
|
OrigFrLot
|
Original From Lot/Serial
|
Original!From Lot/Serial
|
x(18)
|
|
|
|
OrigFrPart
|
Original From Item Number
|
Original!From Item Number
|
x(18)
|
|
|
|
OrigFrRef
|
Original From Reference
|
Original!From Ref
|
x(8)
|
|
|
|
OrigToLoc
|
Original To Location
|
Original!To Loc
|
x(8)
|
|
|
|
OrigToLot
|
Original To Lot/Serial
|
Original!To Lot/Serial
|
x(18)
|
|
|
|
OrigToPart
|
Original To Item Number
|
Original!To Item Number
|
x(18)
|
|
|
|
OrigToRef
|
Original To Reference
|
Original!To Reference
|
x(8)
|
|
|
|
Project
|
Project
|
|
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
|
|
|
QadC05
|
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
|
|
|
|
QtyAct
|
Actual
|
|
->,>>>,>>9.9<<<<<<<<
|
10
|
|
|
QtyExp
|
Expected
|
|
->,>>>,>>9.9<<<<<<<<
|
10
|
|
|
Reason
|
Reason
|
|
x(8)
|
|
|
|
RecDSet
|
Receipt Data Set
|
|
x(12)
|
|
|
|
Receiver
|
Receiver
|
|
x(8)
|
|
|
|
RecLine
|
Receipt Line/ID
|
Receipt!Line/ID
|
x(8)
|
|
|
|
RecNbr
|
Receipt Order
|
|
x(18)
|
|
|
|
RecReqNbr
|
Requisition
|
|
x(8)
|
|
|
|
RecTrNbr
|
Receipt
|
|
>>>>>>>>>9
|
|
|
|
RelNbr
|
Release Group Nbr
|
Rel Grp
|
>>>>>>>9
|
|
|
|
Rmks
|
Remarks
|
|
x(24)
|
|
|
|
SampleID
|
Sample ID
|
ID
|
>>>>>>>9
|
|
|
|
SessionID
|
Session ID
|
|
x(24)
|
|
|
|
Site
|
Site
|
|
x(8)
|
|
|
|
SOJob
|
SO Job
|
|
x(8)
|
|
|
|
StageStatus
|
Stage Status
|
Stg
|
x(2)
|
|
|
|
StartDate
|
Started
|
|
99/99/99
|
|
|
|
StartProgname
|
Started
|
|
x(10)
|
|
|
|
StartTime
|
Start Time
|
|
->,>>>,>>9
|
|
|
|
StartUserID
|
Started
|
|
x(8)
|
|
|
|
SystemCode
|
System
|
|
x(2)
|
|
|
|
SystemProcCode
|
Procedure Code
|
Proc
|
x(2)
|
|
|
|
Task
|
Task
|
|
x(8)
|
|
|
|
ToAltUM
|
To UM
|
To!UM
|
x(2)
|
|
|
|
ToDigit
|
To Digit
|
|
x(8)
|
|
|
|
ToLoc
|
To Location
|
To Loc
|
x(8)
|
|
|
|
ToLot
|
To Lot/Serial
|
|
x(18)
|
|
|
|
ToPart
|
To Item Number
|
|
x(18)
|
|
|
|
ToRef
|
To Reference
|
To!Reference
|
x(8)
|
|
|
|
ToSite
|
To Site
|
|
x(8)
|
|
|
|
ToSlocGp
|
To SLocGrp
|
To!SLocGrp
|
x(8)
|
|
|
|
ToWhse
|
To Whse
|
|
x(8)
|
|
|
|
ToWlocgp
|
To WLocGrp
|
To!WLocGrp
|
x(8)
|
|
|
|
TrNbr
|
Transaction
|
Trans
|
>>>>>>>>>9
|
|
|
|
TrPriInc
|
Increment
|
|
->,>>>,>>9
|
|
|
|
TrPriority
|
Priority
|
|
->,>>>,>>9
|
|
|
|
TrStatus
|
Status
|
St
|
x(8)
|
|
|
|
TrType
|
Type
|
|
x(8)
|
|
|
|
TwoPhase
|
Two Phase
|
2Ph
|
yes/no
|
|
|
|
UltLoc
|
Ultimate Location
|
Ultimate!Location
|
x(8)
|
|
|
|
UltSite
|
Ultimate Site
|
Ultimate!Site
|
x(8)
|
|
|
|
UltSlocgp
|
Ultimate SLocGrp
|
Ultimate!SLocGrp
|
x(8)
|
|
|
|
UltWhse
|
Ultimate Warehouse
|
Ultimate!Whse
|
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
|
|
|
UserI01
|
User Field Integer 1
|
|
->>>>>>>9
|
|
|
|
UserI02
|
User Field Integer 2
|
|
->>>>>>>9
|
|
|
|
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 1
|
|
99/99/99
|
|
|
|
WaveNbr
|
Wave Number
|
Wave Nbr
|
x(8)
|
|
|
|
Whse
|
Warehouse
|
Whse
|
x(8)
|
|
|
|
WLocGp
|
Work Loc Group
|
WLocGrp
|
x(8)
|
|
|
|
xPrevQtyAct
|
Previous Actual
|
Previous!Actual
|
->,>>>,>>9.9<<<<<<<<
|
10
|
|
|
Index-Name
|
Uni
|
Field-Name
|
Asc
|
Abbr
|
|
|
FromLoc
|
no
|
Domain
|
yes
|
no
|
|
|
|
|
FromSite
|
yes
|
no
|
|
|
|
|
FromWhse
|
yes
|
no
|
|
|
|
|
FromLoc
|
yes
|
no
|
|
|
|
|
FromPart
|
yes
|
no
|
|
|
|
|
FromLot
|
yes
|
no
|
|
|
|
|
FromRef
|
yes
|
no
|
|
|
FromPart
|
no
|
Domain
|
yes
|
no
|
|
|
|
|
FromPart
|
yes
|
no
|
|
|
FromSLocGp
|
no
|
Domain
|
yes
|
no
|
|
|
|
|
FromSite
|
yes
|
no
|
|
|
|
|
FromWhse
|
yes
|
no
|
|
|
|
|
FromSlocgp
|
yes
|
no
|
|
|
|
|
FromPart
|
yes
|
no
|
|
|
|
|
FromLot
|
yes
|
no
|
|
|
|
|
FromRef
|
yes
|
no
|
|
|
|
|
TrNbr
|
yes
|
no
|
|
|
InventNbr
|
no
|
Domain
|
yes
|
no
|
|
|
|
|
InventNbr
|
yes
|
no
|
|
|
IssOrder
|
no
|
Domain
|
yes
|
no
|
|
|
|
|
IssDSet
|
yes
|
no
|
|
|
|
|
IssNbr
|
yes
|
no
|
|
|
|
|
IssLine
|
yes
|
no
|
|
|
oid_TranD
|
yes
|
oid_TranD
|
yes
|
no
|
|
|
RecOrder
|
no
|
Domain
|
yes
|
no
|
|
|
|
|
RecDSet
|
yes
|
no
|
|
|
|
|
RecNbr
|
yes
|
no
|
|
|
|
|
RecLine
|
yes
|
no
|
|
|
RelGroup
|
no
|
Domain
|
yes
|
no
|
|
|
|
|
Site
|
yes
|
no
|
|
|
|
|
Whse
|
yes
|
no
|
|
|
|
|
RelNbr
|
yes
|
no
|
|
|
SampleID
|
no
|
Domain
|
yes
|
no
|
|
|
|
|
SampleID
|
yes
|
no
|
|
|
|
|
TrType
|
yes
|
no
|
|
|
SessionID
|
no
|
Domain
|
yes
|
no
|
|
|
|
|
SessionID
|
yes
|
no
|
|
|
SiteWhse
|
no
|
Domain
|
yes
|
no
|
|
|
|
|
Site
|
yes
|
no
|
|
|
|
|
Whse
|
yes
|
no
|
|
|
|
|
TrStatus
|
yes
|
no
|
|
|
StatusTo
|
no
|
Domain
|
yes
|
no
|
|
|
|
|
TrStatus
|
yes
|
no
|
|
|
|
|
ToSite
|
yes
|
no
|
|
|
|
|
ToLoc
|
yes
|
no
|
|
|
Task
|
no
|
Domain
|
yes
|
no
|
|
|
|
|
SystemCode
|
yes
|
no
|
|
|
|
|
Task
|
yes
|
no
|
|
|
|
|
Site
|
yes
|
no
|
|
|
|
|
Whse
|
yes
|
no
|
|
|
ToLoc
|
no
|
Domain
|
yes
|
no
|
|
|
|
|
ToSite
|
yes
|
no
|
|
|
|
|
ToWhse
|
yes
|
no
|
|
|
|
|
ToLoc
|
yes
|
no
|
|
|
|
|
ToPart
|
yes
|
no
|
|
|
|
|
ToLot
|
yes
|
no
|
|
|
|
|
ToRef
|
yes
|
no
|
|
|
ToPart
|
no
|
Domain
|
yes
|
no
|
|
|
|
|
ToPart
|
yes
|
no
|
|
∗
|
TrNbr
|
yes
|
Domain
|
yes
|
no
|
|
|
|
|
TrNbr
|
yes
|
no
|
|
|
TrStatus
|
no
|
Domain
|
yes
|
no
|
|
|
|
|
TrStatus
|
yes
|
no
|
|
|
|
|
SystemCode
|
yes
|
no
|
|
|
|
|
SystemProcCode
|
yes
|
no
|
|
|
UltLoc
|
no
|
Domain
|
yes
|
no
|
|
|
|
|
UltSite
|
yes
|
no
|
|
|
|
|
UltWhse
|
yes
|
no
|
|
|
|
|
UltSlocgp
|
yes
|
no
|
|
|
|
|
UltLoc
|
yes
|
no
|
|
|
UltSiteLoc
|
no
|
Domain
|
yes
|
no
|
|
|
|
|
UltSite
|
yes
|
no
|
|
|
|
|
UltLoc
|
yes
|
no
|
|
|
UsrIdx
|
no
|
Domain
|
yes
|
no
|
|
|
|
|
User1
|
yes
|
no
|
|
|
|
|
User2
|
yes
|
no
|
|
|
Wave
|
no
|
Domain
|
yes
|
no
|
|
|
|
|
Site
|
yes
|
no
|
|
|
|
|
Whse
|
yes
|
no
|
|
|
|
|
WaveNbr
|
yes
|
no
|
|
|
WLocGp
|
no
|
Domain
|
yes
|
no
|
|
|
|
|
Site
|
yes
|
no
|
|
|
|
|
Whse
|
yes
|
no
|
|
|
|
|
WLocGp
|
yes
|
no
|
|
|
Field Name
|
Label
|
Col-Label
|
Format
|
Dec
|
|
|
ABSID
|
ABS ID
|
|
x(8)
|
|
|
|
ABSShipFrom
|
Ship From
|
|
x(8)
|
|
|
|
Addr
|
Address
|
|
x(8)
|
|
|
|
AlgoNbr
|
Algorithm
|
Algo
|
>>9
|
|
|
|
AlgoType
|
Type
|
|
X(2)
|
|
|
|
BulkPick
|
Bulk Pick
|
Bulk!Pick
|
x(8)
|
|
|
|
CloseDate
|
Closed
|
|
99/99/99
|
|
|
|
CloseProgname
|
Closed
|
|
x(10)
|
|
|
|
CloseTime
|
|
|
->,>>>,>>9
|
|
|
|
CloseUserID
|
Closed
|
|
x(8)
|
|
|
|
CmtIndx
|
Comments
|
|
>>>>>>>9
|
|
|
|
CompDate
|
Completed
|
|
99/99/99
|
|
|
|
CompTime
|
|
|
->,>>>,>>9
|
|
|
|
CreateDate
|
Create Date
|
|
99/99/99
|
|
|
|
CreateProgName
|
Created
|
|
x(10)
|
|
|
|
CreateTime
|
Created Time
|
|
->,>>>,>>9
|
|
|
|
CreateUserID
|
Created UserID
|
|
x(8)
|
|
|
|
CurrUserID
|
Current
|
|
x(8)
|
|
|
|
Domain
|
Domain
|
|
x(8)
|
|
|
|
ExistSample
|
Exist Sample
|
|
yes/no
|
|
|
|
Fail
|
Fail
|
|
yes/no
|
|
|
|
FromAltUM
|
From UM
|
Fr!UM
|
x(2)
|
|
|
|
FromDigit
|
From Digit
|
From!Digit
|
x(8)
|
|
|
|
FromLoc
|
From Location
|
From!Location
|
x(8)
|
|
|
|
FromLot
|
From Lot/Serial
|
|
x(18)
|
|
|
|
FromPart
|
From Item Number
|
|
x(18)
|
|
|
|
FromRef
|
From Reference
|
From!Reference
|
x(8)
|
|
|
|
FromSite
|
From Site
|
From!Site
|
x(8)
|
|
|
|
FromSlocgp
|
From SLocGrp
|
From!SLocGrp
|
x(8)
|
|
|
|
FromWhse
|
From Whse
|
From!Whse
|
x(8)
|
|
|
|
FromWlocgp
|
From WLocGrp
|
From!WLocGrp
|
x(8)
|
|
|
|
HardAssign
|
Hard Assignment
|
Hard
|
yes/no
|
|
|
|
IntRouteCode
|
Internal Routing
|
Internal!Routing
|
x(8)
|
|
|
|
IntRouteSeq
|
Seq
|
|
>>9
|
|
|
|
InventNbr
|
Internal Inventory ID
|
Internal!Invent ID
|
99999999
|
|
|
|
IssDSet
|
Issue Data Set
|
|
x(12)
|
|
|
|
IssLine
|
Issue Line/ID
|
Issue!Line/ID
|
x(8)
|
|
|
|
IssNbr
|
Issue Order
|
|
x(18)
|
|
|
|
IssTrNbr
|
Issue
|
|
>>>>>>>>>9
|
|
|
|
KeepFromStatus
|
Keep From Status
|
Keep!From!Status
|
yes/no
|
|
|
|
ModDate
|
Modified
|
|
99/99/99
|
|
|
|
ModeM
|
Mode
|
|
X(8)
|
|
|
|
ModUserID
|
Modified
|
|
x(8)
|
|
|
|
oid_TranH
|
|
|
>>>>>>>>>>>>>>>>>>>>>>>>>>>9.9<<<<<<<<<
|
10
|
|
|
OrigFrLoc
|
Original From Location
|
Original!From Loc
|
x(8)
|
|
|
|
OrigFrLot
|
Original From Lot/Serial
|
Original!From Lot/Serial
|
x(18)
|
|
|
|
OrigFrPart
|
Original From Item Number
|
Original!From Item Number
|
x(18)
|
|
|
|
OrigFrRef
|
Original From Reference
|
Original!From Ref
|
x(8)
|
|
|
|
OrigToLoc
|
Original To Location
|
Original!To Loc
|
x(8)
|
|
|
|
OrigToLot
|
Original To Lot/Serial
|
Original!To Lot/Serial
|
x(18)
|
|
|
|
OrigToPart
|
Original To Item Number
|
Original!To Item Number
|
x(18)
|
|
|
|
OrigToRef
|
Original To Reference
|
Original!To Reference
|
x(8)
|
|
|
|
Project
|
Project
|
|
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
|
|
|
QadC05
|
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
|
|
|
|
QtyAct
|
Actual
|
|
->,>>>,>>9.9<<<<<<<<
|
10
|
|
|
QtyExp
|
Expected
|
|
->,>>>,>>9.9<<<<<<<<
|
10
|
|
|
Reason
|
Reason
|
|
x(8)
|
|
|
|
RecDSet
|
Receipt Data Set
|
|
x(12)
|
|
|
|
Receiver
|
Receiver
|
|
x(8)
|
|
|
|
RecLine
|
Receipt Line/ID
|
Receipt!Line/ID
|
x(8)
|
|
|
|
RecNbr
|
Receipt Order
|
|
x(18)
|
|
|
|
RecReqNbr
|
Requisition
|
|
x(8)
|
|
|
|
RecTrNbr
|
Receipt
|
|
>>>>>>>>>9
|
|
|
|
RelNbr
|
Release Group Nbr
|
Rel Grp
|
>>>>>>>9
|
|
|
|
Rmks
|
Remarks
|
|
x(24)
|
|
|
|
SampleID
|
Sample ID
|
ID
|
>>>>>>>9
|
|
|
|
SessionID
|
Session ID
|
|
x(24)
|
|
|
|
Site
|
Site
|
|
x(8)
|
|
|
|
SOJob
|
SO Job
|
|
x(8)
|
|
|
|
StageStatus
|
Stage Status
|
Stg
|
x(2)
|
|
|
|
StartDate
|
Started
|
|
99/99/99
|
|
|
|
StartProgname
|
Started
|
|
x(10)
|
|
|
|
StartTime
|
|
|
->,>>>,>>9
|
|
|
|
StartUserID
|
Started
|
|
x(8)
|
|
|
|
SystemCode
|
System
|
|
x(2)
|
|
|
|
SystemProcCode
|
Procedure Code
|
Proc
|
x(2)
|
|
|
|
Task
|
Task
|
|
x(8)
|
|
|
|
ToAltUM
|
To UM
|
To!UM
|
x(2)
|
|
|
|
ToDigit
|
To Digit
|
|
x(8)
|
|
|
|
ToLoc
|
To Location
|
To Loc
|
x(8)
|
|
|
|
ToLot
|
To Lot/Serial
|
|
x(18)
|
|
|
|
ToPart
|
To Item Number
|
|
x(18)
|
|
|
|
ToRef
|
To Reference
|
To!Reference
|
x(8)
|
|
|
|
ToSite
|
To Site
|
|
x(8)
|
|
|
|
ToSlocGp
|
To SLocGrp
|
To!SLocGrp
|
x(8)
|
|
|
|
ToWhse
|
To Whse
|
|
x(8)
|
|
|
|
ToWlocgp
|
To WLocGrp
|
To!WLocGrp
|
x(8)
|
|
|
|
TrNbr
|
Transaction
|
Trans
|
>>>>>>>>>9
|
|
|
|
TrPriInc
|
Increment
|
|
->,>>>,>>9
|
|
|
|
TrPriority
|
Priority
|
|
->,>>>,>>9
|
|
|
|
TrSeq
|
Sequence
|
Seq
|
>>>9
|
|
|
|
TrStatus
|
Status
|
St
|
x(8)
|
|
|
|
TrType
|
Type
|
|
x(8)
|
|
|
|
TwoPhase
|
Two Phase
|
2Ph
|
yes/no
|
|
|
|
UltLoc
|
Ultimate Location
|
Ultimate!Location
|
x(8)
|
|
|
|
UltSite
|
Ultimate Site
|
Ultimate!Site
|
x(8)
|
|
|
|
UltSlocgp
|
Ultimate SLocGrp
|
Ultimate!SLocGrp
|
x(8)
|
|
|
|
UltWhse
|
Ultimate Warehouse
|
Ultimate!Whse
|
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
|
|
|
UserI01
|
User Field Integer 1
|
|
->>>>>>>9
|
|
|
|
UserI02
|
User Field Integer 2
|
|
->>>>>>>9
|
|
|
|
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 1
|
|
99/99/99
|
|
|
|
WaveNbr
|
Wave Number
|
Wave Nbr
|
x(8)
|
|
|
|
Whse
|
Warehouse
|
Whse
|
x(8)
|
|
|
|
WLocGp
|
Work Loc Group
|
WLocGrp
|
x(8)
|
|
|
|
xPrevQtyAct
|
Previous Actual
|
Previous!Actual
|
->,>>>,>>9.9<<<<<<<<
|
10
|
|
|
Index-Name
|
Uni
|
Field-Name
|
Asc
|
Abbr
|
|
|
CloseUser
|
no
|
Domain
|
yes
|
no
|
|
|
|
|
CloseUserID
|
yes
|
no
|
|
|
|
|
CloseDate
|
yes
|
no
|
|
|
|
|
CloseTime
|
yes
|
no
|
|
|
FromLoc
|
no
|
Domain
|
yes
|
no
|
|
|
|
|
FromSite
|
yes
|
no
|
|
|
|
|
FromWhse
|
yes
|
no
|
|
|
|
|
FromLoc
|
yes
|
no
|
|
|
|
|
FromPart
|
yes
|
no
|
|
|
|
|
FromLot
|
yes
|
no
|
|
|
|
|
FromRef
|
yes
|
no
|
|
|
FromPart
|
no
|
Domain
|
yes
|
no
|
|
|
|
|
FromPart
|
yes
|
no
|
|
|
FromSLocGp
|
no
|
Domain
|
yes
|
no
|
|
|
|
|
FromSite
|
yes
|
no
|
|
|
|
|
FromWhse
|
yes
|
no
|
|
|
|
|
FromSlocgp
|
yes
|
no
|
|
|
|
|
FromPart
|
yes
|
no
|
|
|
|
|
FromLot
|
yes
|
no
|
|
|
|
|
FromRef
|
yes
|
no
|
|
|
|
|
TrNbr
|
yes
|
no
|
|
|
|
|
TrSeq
|
yes
|
no
|
|
|
IssOrder
|
no
|
Domain
|
yes
|
no
|
|
|
|
|
IssDSet
|
yes
|
no
|
|
|
|
|
IssNbr
|
yes
|
no
|
|
|
|
|
IssLine
|
yes
|
no
|
|
|
oid_TranH
|
yes
|
oid_TranH
|
yes
|
no
|
|
|
RecOrder
|
no
|
Domain
|
yes
|
no
|
|
|
|
|
RecDSet
|
yes
|
no
|
|
|
|
|
RecNbr
|
yes
|
no
|
|
|
|
|
RecLine
|
yes
|
no
|
|
|
RelGroup
|
no
|
Domain
|
yes
|
no
|
|
|
|
|
Site
|
yes
|
no
|
|
|
|
|
Whse
|
yes
|
no
|
|
|
|
|
RelNbr
|
yes
|
no
|
|
|
SampleID
|
no
|
Domain
|
yes
|
no
|
|
|
|
|
SampleID
|
yes
|
no
|
|
|
|
|
TrType
|
yes
|
no
|
|
|
SessionID
|
no
|
Domain
|
yes
|
no
|
|
|
|
|
SessionID
|
yes
|
no
|
|
|
StatusTo
|
no
|
Domain
|
yes
|
no
|
|
|
|
|
TrStatus
|
yes
|
no
|
|
|
|
|
ToSite
|
yes
|
no
|
|
|
|
|
ToLoc
|
yes
|
no
|
|
|
Task
|
no
|
Domain
|
yes
|
no
|
|
|
|
|
SystemCode
|
yes
|
no
|
|
|
|
|
Task
|
yes
|
no
|
|
|
|
|
Site
|
yes
|
no
|
|
|
|
|
Whse
|
yes
|
no
|
|
|
ToLoc
|
no
|
Domain
|
yes
|
no
|
|
|
|
|
ToSite
|
yes
|
no
|
|
|
|
|
ToWhse
|
yes
|
no
|
|
|
|
|
ToLoc
|
yes
|
no
|
|
|
|
|
ToPart
|
yes
|
no
|
|
|
|
|
ToLot
|
yes
|
no
|
|
|
|
|
ToRef
|
yes
|
no
|
|
|
ToPart
|
no
|
Domain
|
yes
|
no
|
|
|
|
|
ToPart
|
yes
|
no
|
|
∗
|
TrNbrSeq
|
yes
|
Domain
|
yes
|
no
|
|
|
|
|
TrNbr
|
yes
|
no
|
|
|
|
|
TrSeq
|
yes
|
no
|
|
|
TrStatus
|
no
|
Domain
|
yes
|
no
|
|
|
|
|
TrStatus
|
yes
|
no
|
|
|
|
|
SystemCode
|
yes
|
no
|
|
|
|
|
SystemProcCode
|
yes
|
no
|
|
|
UsrIdx
|
no
|
Domain
|
yes
|
no
|
|
|
|
|
User1
|
yes
|
no
|
|
|
|
|
User2
|
yes
|
no
|
|
|
Wave
|
no
|
Domain
|
yes
|
no
|
|
|
|
|
Site
|
yes
|
no
|
|
|
|
|
Whse
|
yes
|
no
|
|
|
|
|
WaveNbr
|
yes
|
no
|
|
|
Field Name
|
Label
|
Col-Label
|
Format
|
Dec
|
|
|
Country_ID
|
Link to Country
|
|
-99999999999
|
|
|
|
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
|
|
99/99/9999
|
|
|
|
LastModifiedTime
|
Last Modified Time
|
|
99999
|
|
|
|
LastModifiedUser
|
Last Modified User
|
|
x(20)
|
|
|
|
QADC01
|
|
|
x(40)
|
|
|
|
QADC02
|
|
|
x(255)
|
|
|
|
QADD01
|
|
|
->,>>>,>>9.9999
|
10
|
|
|
QADT01
|
|
|
99/99/9999
|
|
|
|
TransactionType_ID
|
Record ID
|
|
-99999999999
|
|
|
|
TransactionTypeCode
|
Code
|
|
x(20)
|
|
|
|
TransactionTypeDescription
|
Description
|
|
x(40)
|
|
|
|
TransactionTypeIsActive
|
Active
|
|
yes/no
|
|
|
|
Index-Name
|
Uni
|
Field-Name
|
Asc
|
Abbr
|
|
|
ActiveIdx
|
no
|
TransactionTypeIsActive
|
yes
|
no
|
|
|
CntCodeIdx
|
yes
|
Country_ID
|
yes
|
no
|
|
|
|
|
TransactionTypeCode
|
yes
|
no
|
|
∗
|
Prim
|
yes
|
TransactionType_ID
|
yes
|
no
|
|
|
ViewIndex
|
no
|
TransactionTypeIsActive
|
yes
|
no
|
|
|
|
|
TransactionTypeCode
|
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
|
|
99/99/9999
|
|
|
|
LastModifiedTime
|
Last Modified Time
|
|
99999
|
|
|
|
LastModifiedUser
|
Last Modified User
|
|
x(20)
|
|
|
|
QADC01
|
|
|
x(40)
|
|
|
|
QADC02
|
|
|
x(255)
|
|
|
|
QADD01
|
|
|
->,>>>,>>9.9999
|
10
|
|
|
QADT01
|
|
|
99/99/9999
|
|
|
|
TransportMeans_ID
|
Record ID
|
|
-99999999999
|
|
|
|
TransportMeansCode
|
Code
|
|
x(20)
|
|
|
|
TransportMeansDescription
|
Description
|
|
x(40)
|
|
|
|
TransportMeansIsActive
|
Active
|
|
yes/no
|
|
|
|
TransportMeansIsDefault
|
Default
|
|
yes/no
|
|
|
|
Index-Name
|
Uni
|
Field-Name
|
Asc
|
Abbr
|
|
|
ActiveIdx
|
no
|
TransportMeansIsActive
|
yes
|
no
|
|
|
CodeIdx
|
yes
|
TransportMeansCode
|
yes
|
no
|
|
∗
|
Prim
|
yes
|
TransportMeans_ID
|
yes
|
no
|
|
|
ViewIndex
|
no
|
TransportMeansIsActive
|
yes
|
no
|
|
|
|
|
TransportMeansCode
|
yes
|
no
|
|
|
Field Name
|
Label
|
Col-Label
|
Format
|
Dec
|
|
|
CmtIndx
|
Comments
|
|
>>>>>>>9
|
|
|
|
Consolidate
|
Consolidate
|
Cons
|
yes/no
|
|
|
|
CreateDate
|
Create Date
|
|
99/99/99
|
|
|
|
CreateUserID
|
Created
|
|
x(8)
|
|
|
|
Description
|
Description
|
|
x(24)
|
|
|
|
Domain
|
Domain
|
|
x(8)
|
|
|
|
ModDate
|
Modified
|
|
99/99/99
|
|
|
|
ModeM
|
Mode
|
|
X(8)
|
|
|
|
ModUserID
|
Modified
|
|
x(8)
|
|
|
|
oid_TranTypeM
|
|
|
>>>>>>>>>>>>>>>>>>>>>>>>>>>9.9<<<<<<<<<
|
10
|
|
|
OverPick
|
Over Pick
|
Over!Pick
|
yes/no
|
|
|
|
PrintProcCode
|
Print Procedure Code
|
Print!Proc
|
x(2)
|
|
|
|
QadC01
|
QAD Field
|
|
X(8)
|
0
|
|
|
QadC02
|
QAD Field
|
|
X(8)
|
0
|
|
|
QadC03
|
QAD Field
|
|
X(8)
|
0
|
|
|
QadC04
|
QAD Field
|
|
X(8)
|
0
|
|
|
QadC05
|
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
|
|
|
|
ShortAction
|
Shortage Action
|
Short!Act
|
>>9
|
|
|
|
ShortDef
|
Shortage Definition
|
Short!Def
|
>>9
|
|
|
|
ShortQtyDef
|
Shortage Quantity Definition
|
Short!Qty Def
|
>>9
|
|
|
|
ShortWindow
|
Shortage Window
|
Short!Wind
|
>>9
|
|
|
|
SLGListSearchExt
|
SLG List Search Extension
|
SLG List Ext
|
yes/no
|
|
|
|
SLGOPControl
|
Control Over-Pick at SLG
|
|
yes/no
|
|
|
|
SLGSearchExt
|
SLG Search Extension
|
SLG Ext
|
yes/no
|
|
|
|
TrType
|
Type
|
|
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
|
|
|
UserI01
|
User Field Integer 1
|
|
->>>>>>>9
|
|
|
|
UserI02
|
User Field Integer 2
|
|
->>>>>>>9
|
|
|
|
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 1
|
|
99/99/99
|
|
|
|
Index-Name
|
Uni
|
Field-Name
|
Asc
|
Abbr
|
|
|
oid_TranTypeM
|
yes
|
oid_TranTypeM
|
yes
|
no
|
|
∗
|
TrType
|
yes
|
Domain
|
yes
|
no
|
|
|
|
|
TrType
|
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
|
|
|
|
CreateProgName
|
Created
|
|
x(10)
|
|
|
|
CreateUserID
|
Created
|
|
x(8)
|
|
|
|
Domain
|
Domain
|
|
x(8)
|
|
|
|
InternalID
|
Internal User ID
|
Internal!User ID
|
x(50)
|
|
|
|
ModDate
|
Modified Date
|
Mod Date
|
99/99/99
|
|
|
|
ModUserID
|
User ID
|
|
x(8)
|
|
|
|
oid_TranW
|
|
|
>>>>>>>>>>>>>>>>>>>>>>>>>>>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
|
|
|
QadC05
|
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
|
|
|
|
TrNbr
|
Transaction
|
Trans
|
>>>>>>>>>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
|
|
|
UserI01
|
User Field Integer 1
|
|
->>>>>>>9
|
|
|
|
UserI02
|
User Field Integer 2
|
|
->>>>>>>9
|
|
|
|
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 1
|
|
99/99/99
|
|
|
|
WkType
|
Type
|
|
x(8)
|
|
|
|
Index-Name
|
Uni
|
Field-Name
|
Asc
|
Abbr
|
|
|
oid_TranW
|
yes
|
oid_TranW
|
yes
|
no
|
|
∗
|
UserTypeTran
|
yes
|
Domain
|
yes
|
no
|
|
|
|
|
InternalID
|
yes
|
no
|
|
|
|
|
WkType
|
yes
|
no
|
|
|
|
|
TrNbr
|
yes
|
no
|
|
|
UsrIdx
|
no
|
Domain
|
yes
|
no
|
|
|
|
|
User1
|
yes
|
no
|
|
|
|
|
User2
|
yes
|
no
|
|
|
Field Name
|
Label
|
Col-Label
|
Format
|
Dec
|
|
|
oid_trcs_det
|
|
|
>>>>>>>>>>>>>>>>>>>>>>>>>>>9.9<<<<<<<<<
|
10
|
|
|
trcs__qad01
|
|
|
x(8)
|
|
|
|
trcs__qad02
|
|
|
x(8)
|
|
|
|
trcs__qad03
|
|
|
x(8)
|
|
|
|
trcs__qad04
|
|
|
>>>,>>>,>>9.99
|
10
|
|
|
trcs__qad05
|
|
|
>>>,>>>,>>9.99
|
10
|
|
|
trcs__qad06
|
|
|
>>>,>>>,>>9.99
|
10
|
|
|
trcs__qad07
|
|
|
99/99/99
|
|
|
|
trcs__qad08
|
|
|
99/99/99
|
|
|
|
trcs__qad09
|
|
|
99/99/99
|
|
|
|
trcs__qad10
|
|
|
yes/no
|
|
|
|
trcs_bdn_std
|
Burden
|
|
->>>,>>>,>>9.99<<<
|
10
|
|
|
trcs_curr
|
Currency
|
Cur
|
x(3)
|
|
|
|
trcs_domain
|
Domain
|
|
x(8)
|
|
|
|
trcs_ex_rate
|
Exch Rate
|
|
>>,>>9.99999<<<<<
|
10
|
|
|
trcs_lbr_std
|
Labor
|
|
->>>,>>>,>>9.99<<<
|
10
|
|
|
trcs_mtl_std
|
Material
|
|
->>>,>>>,>>9.99<<<
|
10
|
|
|
trcs_ovh_std
|
Overhead
|
|
>>>>,>>>,>>9.99<<<
|
10
|
|
|
trcs_price
|
Price
|
|
->>>,>>>,>>9.99<<<
|
10
|
|
|
trcs_set
|
Cost Set
|
|
x(8)
|
|
|
|
trcs_sub_std
|
Subcontract
|
|
->>>,>>>,>>9.99<<<
|
10
|
|
|
trcs_trnbr
|
Trans
|
|
>>>>>>>>>>
|
|
|
|
trcs_user1
|
Ufld1
|
|
x(8)
|
|
|
|
trcs_user2
|
Ufld2
|
|
x(8)
|
|
|
|
trcs_userid
|
User ID
|
|
x(8)
|
|
|
|
Index-Name
|
Uni
|
Field-Name
|
Asc
|
Abbr
|
|
|
oid_trcs_det
|
yes
|
oid_trcs_det
|
yes
|
no
|
|
∗
|
trcs_nbr_set
|
yes
|
trcs_domain
|
yes
|
no
|
|
|
|
|
trcs_trnbr
|
yes
|
no
|
|
|
|
|
trcs_set
|
yes
|
no
|
|
|
Field Name
|
Label
|
Col-Label
|
Format
|
Dec
|
|
|
oid_trgl_det
|
|
|
>>>>>>>>>>>>>>>>>>>>>>>>>>>9.9<<<<<<<<<
|
10
|
|
|
trgl__qadc01
|
|
|
x(8)
|
|
|
|
trgl_cr_acct
|
Cr Acct
|
|
x(8)
|
|
|
|
trgl_cr_cc
|
Cr Cost Ctr
|
CC
|
x(4)
|
|
|
|
trgl_cr_line
|
Line
|
|
>>>9
|
|
|
|
trgl_cr_proj
|
Cr Project
|
Project
|
x(8)
|
|
|
|
trgl_cr_sub
|
Cr Sub-Acct
|
Sub-Acct
|
x(8)
|
|
|
|
trgl_domain
|
Domain
|
|
x(8)
|
|
|
|
trgl_dr_acct
|
Dr Acct
|
|
x(8)
|
|
|
|
trgl_dr_cc
|
Dr Cost Ctr
|
CC
|
x(4)
|
|
|
|
trgl_dr_line
|
Line
|
|
>>>9
|
|
|
|
trgl_dr_proj
|
Dr Project
|
Project
|
x(8)
|
|
|
|
trgl_dr_sub
|
Dr Sub-Acct
|
Sub-Acct
|
x(8)
|
|
|
|
trgl_dy_code
|
Daybook
|
|
x(8)
|
|
|
|
trgl_dy_num
|
Entry Number
|
|
x(40)
|
|
|
|
trgl_eff_trans
|
Current
|
|
yes/no
|
|
|
|
trgl_gl_amt
|
Amount
|
|
->>>>>,>>9.99
|
10
|
|
|
trgl_gl_ref
|
GL Reference
|
|
x(14)
|
|
|
|
trgl_sequence
|
Sequence
|
|
->,>>>,>>9
|
|
|
|
trgl_trnbr
|
Transaction
|
Trans
|
>>>>>>>>>9
|
|
|
|
trgl_type
|
Type
|
|
x(8)
|
|
|
|
trgl_user1
|
Ufld1
|
|
x(8)
|
|
|
|
trgl_user2
|
Ufld2
|
|
x(8)
|
|
|
|
Index-Name
|
Uni
|
Field-Name
|
Asc
|
Abbr
|
|
|
oid_trgl_det
|
yes
|
oid_trgl_det
|
yes
|
no
|
|
|
trgl_dr_cr
|
no
|
trgl_domain
|
yes
|
no
|
|
|
|
|
trgl_dr_acct
|
yes
|
no
|
|
|
|
|
trgl_dr_sub
|
yes
|
no
|
|
|
|
|
trgl_dr_cc
|
yes
|
no
|
|
|
|
|
trgl_cr_acct
|
yes
|
no
|
|
|
|
|
trgl_cr_sub
|
yes
|
no
|
|
|
|
|
trgl_cr_cc
|
yes
|
no
|
|
|
trgl_dy_code
|
no
|
trgl_domain
|
yes
|
no
|
|
|
|
|
trgl_dy_code
|
yes
|
no
|
|
|
|
|
trgl_dy_num
|
yes
|
no
|
|
∗
|
trgl_nbr_ref
|
yes
|
trgl_domain
|
yes
|
no
|
|
|
|
|
trgl_trnbr
|
yes
|
no
|
|
|
|
|
trgl_gl_ref
|
yes
|
no
|
|
|
|
|
trgl_sequence
|
yes
|
no
|
|
|
trgl_ref_nbr
|
no
|
trgl_domain
|
yes
|
no
|
|
|
|
|
trgl_gl_ref
|
yes
|
no
|
|
|
|
|
trgl_trnbr
|
yes
|
no
|
|
|
trgl_type_nbr_ref
|
no
|
trgl_domain
|
yes
|
no
|
|
|
|
|
trgl_type
|
yes
|
no
|
|
|
|
|
trgl_trnbr
|
yes
|
no
|
|
|
|
|
trgl_gl_ref
|
yes
|
no
|
|
|
Field Name
|
Label
|
Col-Label
|
Format
|
Dec
|
|
|
oid_trld_det
|
|
|
>>>>>>>>>>>>>>>>>>>>>>>>>>>9.9<<<<<<<<<
|
10
|
|
|
trld__chr01
|
|
|
x(8)
|
|
|
|
trld__log01
|
|
|
yes/no
|
|
|
|
trld__qad01
|
|
|
x(8)
|
|
|
|
trld__qad02
|
|
|
x(8)
|
|
|
|
trld__qad03
|
|
|
->>>,>>>,>>9.99
|
10
|
|
|
trld__qad04
|
|
|
99/99/99
|
|
|
|
trld__qad05
|
|
|
yes/no
|
|
|
|
trld_code
|
Trailer Code
|
Trl!Code
|
x(4)
|
|
|
|
trld_domain
|
Domain
|
|
x(8)
|
|
|
|
trld_tax_type
|
Tax Type
|
|
x(16)
|
|
|
|
trld_taxable
|
Taxable
|
|
yes/no
|
|
|
|
trld_taxc
|
Tax Class
|
TxC
|
x(3)
|
|
|
|
trld_user1
|
Ufld1
|
|
x(8)
|
|
|
|
trld_user2
|
Ufld2
|
|
x(8)
|
|
|
|
Index-Name
|
Uni
|
Field-Name
|
Asc
|
Abbr
|
|
|
oid_trld_det
|
yes
|
oid_trld_det
|
yes
|
no
|
|
∗
|
trld_code_type
|
yes
|
trld_domain
|
yes
|
no
|
|
|
|
|
trld_code
|
yes
|
no
|
|
|
|
|
trld_tax_type
|
yes
|
no
|
|
|
Field Name
|
Label
|
Col-Label
|
Format
|
Dec
|
|
|
oid_trl_mstr
|
|
|
>>>>>>>>>>>>>>>>>>>>>>>>>>>9.9<<<<<<<<<
|
10
|
|
|
trl__qadc01
|
|
|
x(8)
|
|
|
|
trl_acct
|
Trailer Acct
|
Acct
|
x(8)
|
|
|
|
trl_cc
|
Trailer CC
|
CC
|
x(4)
|
|
|
|
trl_code
|
Trailer Code
|
Code
|
x(2)
|
|
|
|
trl_desc
|
Description
|
|
x(24)
|
|
|
|
trl_domain
|
Domain
|
|
x(8)
|
|
|
|
trl_fst
|
FST
|
|
yes/no
|
|
|
|
trl_project
|
Project
|
|
x(8)
|
|
|
|
trl_pst
|
PST
|
|
yes/no
|
|
|
|
trl_sub
|
Trailer Sub-Acct
|
Sub-Acct
|
x(8)
|
|
|
|
trl_taxable
|
Taxable
|
|
yes/no
|
|
|
|
trl_taxc
|
Tax Class
|
TxC
|
x(3)
|
|
|
|
trl_user1
|
Ufld1
|
|
x(8)
|
|
|
|
trl_user2
|
Ufld2
|
|
x(8)
|
|
|
|
Index-Name
|
Uni
|
Field-Name
|
Asc
|
Abbr
|
|
|
oid_trl_mstr
|
yes
|
oid_trl_mstr
|
yes
|
no
|
|
∗
|
trl_code
|
yes
|
trl_domain
|
yes
|
no
|
|
|
|
|
trl_code
|
yes
|
no
|
|
|
Field Name
|
Label
|
Col-Label
|
Format
|
Dec
|
|
|
oid_trq_mstr
|
|
|
>>>>>>>>>>>>>>>>>>>>>>>>>>>9.9<<<<<<<<<
|
10
|
|
|
trq__qadc01
|
|
|
x(8)
|
|
|
|
trq_add_ref
|
Add Ref
|
|
x(8)
|
|
|
|
trq_doc_ref
|
Doc Ref
|
|
x(8)
|
|
|
|
trq_doc_type
|
Doc Type
|
|
x(3)
|
|
|
|
trq_domain
|
Domain
|
|
x(8)
|
|
|
|
trq_id
|
Transmission Number
|
Transm
|
>>>>>>9
|
|
|
|
trq_mod_date
|
Modified Date
|
Mod Date
|
99/99/99
|
|
|
|
trq_mod_userid
|
User ID
|
|
x(16)
|
|
|
|
trq_msg_type
|
Type
|
|
x(8)
|
|
|
|
trq_user1
|
Ufld1
|
|
x(8)
|
|
|
|
trq_user2
|
Ufld2
|
|
x(8)
|
|
|
|
Index-Name
|
Uni
|
Field-Name
|
Asc
|
Abbr
|
|
|
oid_trq_mstr
|
yes
|
oid_trq_mstr
|
yes
|
no
|
|
|
trq_doc_type
|
yes
|
trq_domain
|
yes
|
no
|
|
|
|
|
trq_doc_type
|
yes
|
no
|
|
|
|
|
trq_doc_ref
|
yes
|
no
|
|
|
|
|
trq_add_ref
|
yes
|
no
|
|
∗
|
trq_id
|
yes
|
trq_domain
|
yes
|
no
|
|
|
|
|
trq_id
|
yes
|
no
|
|
|
Field Name
|
Label
|
Col-Label
|
Format
|
Dec
|
|
|
oid_lgd_mstr
|
|
|
>>>>>>>>>>>>>>>>>>>>>>>>>>>9.9<<<<<<<<<
|
10
|
|
|
oid_tr_hist
|
|
|
>>>>>>>>>>>>>>>>>>>>>>>>>>>9.9<<<<<<<<<
|
10
|
|
|
tr__chr01
|
|
|
x(8)
|
|
|
|
tr__chr02
|
|
|
x(8)
|
|
|
|
tr__chr03
|
|
|
x(8)
|
|
|
|
tr__chr04
|
|
|
x(8)
|
|
|
|
tr__chr05
|
|
|
x(8)
|
|
|
|
tr__chr06
|
|
|
x(8)
|
|
|
|
tr__chr07
|
|
|
x(8)
|
|
|
|
tr__chr08
|
|
|
x(8)
|
|
|
|
tr__chr09
|
|
|
x(8)
|
|
|
|
tr__chr10
|
|
|
x(8)
|
|
|
|
tr__chr11
|
|
|
x(8)
|
|
|
|
tr__chr12
|
|
|
x(8)
|
|
|
|
tr__chr13
|
|
|
x(8)
|
|
|
|
tr__chr14
|
|
|
x(8)
|
|
|
|
tr__chr15
|
|
|
x(8)
|
|
|
|
tr__dec01
|
|
|
>>>,>>>,>>9.99
|
10
|
|
|
tr__dec02
|
|
|
>>>,>>>,>>9.99
|
10
|
|
|
tr__dec03
|
|
|
>>>,>>>,>>9.99
|
10
|
|
|
tr__dec04
|
|
|
>>>,>>>,>>9.99
|
10
|
|
|
tr__dec05
|
|
|
>>>,>>>,>>9.99
|
10
|
|
|
tr__dte01
|
|
|
99/99/99
|
|
|
|
tr__dte02
|
|
|
99/99/99
|
|
|
|
tr__dte03
|
|
|
99/99/99
|
|
|
|
tr__dte04
|
|
|
99/99/99
|
|
|
|
tr__dte05
|
|
|
99/99/99
|
|
|
|
tr__log01
|
|
|
yes/no
|
|
|
|
tr__log02
|
|
|
yes/no
|
|
|
|
tr_addr
|
Address
|
|
x(8)
|
|
|
|
tr_assay
|
Assay %
|
|
>>9.99%
|
10
|
|
|
tr_auto_install
|
Auto Installed
|
|
yes/no
|
|
|
|
tr_batch
|
Batch
|
|
x(18)
|
|
|
|
tr_bdn_std
|
Burden
|
|
->>>,>>>,>>9.99<<<
|
10
|
|
|
tr_begin_qoh
|
Begin Balance
|
|
->,>>>,>>9.9<<<<<<<<
|
10
|
|
|
tr_ca_int_type
|
Work Code
|
|
x(8)
|
|
|
|
tr_ca_opn_date
|
|
|
99/99/99
|
|
|
|
tr_covered_amt
|
Covered Amount
|
|
>>>>,>>>,>>9.99<<<
|
10
|
|
|
tr_cprice
|
Price
|
|
>>>>,>>>,>>9.99<<<
|
10
|
|
|
tr_curr
|
Currency
|
Cur
|
x(3)
|
|
|
|
tr_date
|
Date
|
|
99/99/99
|
|
|
|
tr_daycode
|
Day Code
|
|
x(8)
|
|
|
|
tr_doc_id
|
Document ID
|
|
x(24)
|
|
|
|
tr_domain
|
Domain
|
|
x(8)
|
|
|
|
tr_effdate
|
Effective
|
Eff Date
|
99/99/99
|
|
|
|
tr_enduser
|
End User
|
|
X(8)
|
|
|
|
tr_eng_area
|
Service Area
|
Area
|
x(18)
|
|
|
|
tr_eng_code
|
Engineer Code
|
Eng Code
|
x(8)
|
|
|
|
tr_ex_rate
|
Exch Rate
|
|
>>>>,>>>,>>9.9<<<<<<<<<
|
10
|
|
|
tr_ex_rate2
|
Exch Rate 2
|
|
>>>>,>>>,>>9.9<<<<<<<<<
|
10
|
|
|
tr_ex_ratetype
|
Rate Type
|
|
x(8)
|
|
|
|
tr_expire
|
Expire Date
|
|
99/99/99
|
|
|
|
tr_exru_seq
|
Sequence
|
|
>>>>>>>>9
|
|
|
|
tr_fcg_code
|
Charge Code
|
|
x(8)
|
|
|
|
tr_fldchg_cmtindx
|
Comment
|
|
>>>>>>>9
|
|
|
|
tr_for
|
Service Part
|
|
x(18)
|
|
|
|
tr_fsc_code
|
Service Category
|
|
x(8)
|
|
|
|
tr_fsm_type
|
FSM Type
|
|
x(8)
|
|
|
|
tr_gl_amt
|
Amount
|
|
->>>>>,>>9.99
|
10
|
|
|
tr_gl_date
|
GL Date
|
|
99/99/99
|
|
|
|
tr_grade
|
Grade
|
|
x(2)
|
|
|
|
tr_intercompanyref
|
Inter Company Reference
|
|
>>>>>>>>>>>>>>>>>>>>>>>>>>>9.9<<<<<<<<<
|
10
|
|
|
tr_last_date
|
Last Activity
|
|
99/99/99
|
|
|
|
tr_lbr_std
|
Labor
|
|
->>>,>>>,>>9.99<<<
|
10
|
|
|
tr_line
|
Line
|
Ln
|
>>9
|
|
|
|
tr_loc
|
Loc
|
Location
|
x(8)
|
|
|
|
tr_loc_begin
|
Begin Loc Bal
|
|
->,>>>,>>9.9<<<<<<<<
|
10
|
|
|
tr_lot
|
ID
|
|
x(8)
|
|
|
|
tr_msg
|
Message Number
|
Msg
|
>>>>9
|
|
|
|
tr_mtl_std
|
Material
|
|
->>>,>>>,>>9.99<<<
|
10
|
|
|
tr_nbr
|
Order
|
|
x(18)
|
|
|
|
tr_ord_rev
|
Revision
|
Rev
|
>>9
|
|
|
|
tr_ovh_std
|
Overhead
|
|
>>>>,>>>,>>9.99<<<
|
10
|
|
|
tr_part
|
Item Number
|
|
x(18)
|
|
|
|
tr_pc_sequence
|
PC Sequence
|
|
>>>>>>>>>>>>>>>>>>9
|
|
|
|
tr_per_date
|
Performance Date
|
Perform
|
99/99/99
|
|
|
|
tr_price
|
Price
|
|
->>>,>>>,>>9.99<<<
|
10
|
|
|
tr_prod_line
|
Product Line
|
Line
|
x(4)
|
|
|
|
tr_program
|
Program
|
|
x(12)
|
|
|
|
tr_promise_date
|
Promise Date
|
Promise
|
99/99/99
|
|
|
|
tr_qty_chg
|
Qty Change
|
|
->,>>>,>>9.9<<<<<<<<
|
10
|
|
|
tr_qty_cn_adj
|
Consignment Qty Adjusted
|
|
->,>>>,>>9.9<<<<<<<<
|
10
|
|
|
tr_qty_loc
|
Loc Qty Change
|
|
->,>>>,>>9.9<<<<<<<<
|
10
|
|
|
tr_qty_req
|
Qty Required
|
|
->,>>>,>>9.9<<<<<<<<
|
10
|
|
|
tr_qty_short
|
Qty Short
|
|
->,>>>,>>9.9<<<<<<<<
|
10
|
|
|
tr_ref
|
Ref
|
Reference
|
x(8)
|
|
|
|
tr_ref_site
|
Reference Site
|
Ref Site
|
x(8)
|
|
|
|
tr_rev
|
Rev
|
|
x(4)
|
|
|
|
tr_rmks
|
Remarks
|
|
x(10)
|
|
|
|
tr_rsn_code
|
Reason
|
|
x(8)
|
|
|
|
tr_sa_nbr
|
Contract
|
|
x(8)
|
0
|
|
|
tr_serial
|
Lot/Serial
|
|
x(18)
|
|
|
|
tr_ship_date
|
Ship Date
|
|
99/99/99
|
|
|
|
tr_ship_id
|
Shipper Number
|
|
x(20)
|
|
|
|
tr_ship_inv_mov
|
Inventory Movement Code
|
Inv Mov
|
x(8)
|
|
|
|
tr_ship_type
|
Ship Type
|
T
|
x(1)
|
|
|
|
tr_site
|
Site
|
|
x(8)
|
|
|
|
tr_slspsn[4]
|
Salesperson
|
Salespsn
|
x(8)
|
|
|
|
tr_so_job
|
Sales/Job
|
|
x(8)
|
|
|
|
tr_status
|
Inventory Status
|
Status
|
x(8)
|
|
|
|
tr_sub_std
|
Subcontract
|
|
->>>,>>>,>>9.99<<<
|
10
|
|
|
tr_sv_code
|
Contract Type
|
|
x(8)
|
|
|
|
tr_svc_type
|
|
|
x(1)
|
|
|
|
tr_sys_prod
|
System Product Line
|
S Prod
|
x(4)
|
|
|
|
tr_time
|
Time
|
|
>>,>>>,>>9
|
|
|
|
tr_trnbr
|
Trans
|
|
>>>>>>>>>>
|
|
|
|
tr_type
|
Trans Type
|
Type
|
x(8)
|
|
|
|
tr_um
|
UM
|
|
x(2)
|
|
|
|
tr_upd_isb
|
|
|
yes/no
|
|
|
|
tr_user1
|
Ufld1
|
|
x(8)
|
|
|
|
tr_user2
|
Ufld2
|
|
x(8)
|
|
|
|
tr_userid
|
User ID
|
|
x(8)
|
|
|
|
tr_vend_date
|
Supplier Production Date
|
Prod Date
|
99/99/99
|
|
|
|
tr_vend_lot
|
Supplier Lot
|
|
x(18)
|
|
|
|
tr_wo_due_date
|
Due Date
|
Due
|
99/99/99
|
|
|
|
tr_wo_line
|
Production Line
|
Line
|
x(8)
|
|
|
|
tr_wo_qty_comp
|
Qty Completed
|
|
->,>>>,>>9.9<<<<<<<<
|
10
|
|
|
tr_wo_qty_ord
|
Qty Ordered
|
|
->,>>>,>>9.9<<<<<<<<
|
10
|
|
|
tr_wo_yield_pct
|
Yield
|
|
>>9.99%
|
10
|
|
|
tr_wod_op
|
Operation
|
Op
|
>>>>>>
|
|
|
|
tr_xcr_acct
|
Not Used. Cr Acct
|
|
x(8)
|
|
|
|
tr_xcr_cc
|
Not Used. Cr Cost Ctr
|
CC
|
x(4)
|
|
|
|
tr_xcr_proj
|
Not used. Cr Project
|
Project
|
x(8)
|
|
|
|
tr_xdr_acct
|
Not used. Dr Acct
|
|
x(8)
|
|
|
|
tr_xdr_cc
|
Not used. Dr Cost Ctr
|
CC
|
x(4)
|
|
|
|
tr_xdr_proj
|
Not used. Dr Project
|
Project
|
x(8)
|
|
|
|
tr_xgl_ref
|
Not used. GL Reference
|
|
x(14)
|
|
|
|
tr_xslspsn1
|
Salesperson 1
|
Salespsn
|
x(8)
|
|
|
|
tr_xslspsn2
|
Salesperson 2
|
Salespsn
|
x(8)
|
|
|
|
Index-Name
|
Uni
|
Field-Name
|
Asc
|
Abbr
|
|
|
oid_tr_hist
|
yes
|
oid_tr_hist
|
yes
|
no
|
|
|
tr_addr_eff
|
no
|
tr_domain
|
yes
|
no
|
|
|
|
|
tr_addr
|
yes
|
no
|
|
|
|
|
tr_effdate
|
yes
|
no
|
|
|
tr_batch
|
no
|
tr_domain
|
yes
|
no
|
|
|
|
|
tr_batch
|
yes
|
no
|
|
|
tr_date_trn
|
yes
|
tr_domain
|
yes
|
no
|
|
|
|
|
tr_date
|
yes
|
no
|
|
|
|
|
tr_trnbr
|
yes
|
no
|
|
|
tr_eff_trnbr
|
no
|
tr_domain
|
yes
|
no
|
|
|
|
|
tr_effdate
|
yes
|
no
|
|
|
|
|
tr_trnbr
|
yes
|
no
|
|
|
tr_nbr_eff
|
no
|
tr_domain
|
yes
|
no
|
|
|
|
|
tr_nbr
|
yes
|
no
|
|
|
|
|
tr_effdate
|
yes
|
no
|
|
|
tr_nbr_rmks_type
|
no
|
tr_domain
|
yes
|
no
|
|
|
|
|
tr_nbr
|
yes
|
no
|
|
|
|
|
tr_rmks
|
yes
|
no
|
|
|
|
|
tr_type
|
yes
|
no
|
|
|
tr_oid_lgd_mstr
|
no
|
oid_lgd_mstr
|
yes
|
no
|
|
|
tr_part_eff
|
no
|
tr_domain
|
yes
|
no
|
|
|
|
|
tr_part
|
yes
|
no
|
|
|
|
|
tr_effdate
|
yes
|
no
|
|
|
tr_part_trn
|
no
|
tr_domain
|
yes
|
no
|
|
|
|
|
tr_part
|
yes
|
no
|
|
|
|
|
tr_trnbr
|
yes
|
no
|
|
|
tr_serial
|
no
|
tr_domain
|
yes
|
no
|
|
|
|
|
tr_serial
|
yes
|
no
|
|
|
tr_shipper
|
no
|
tr_domain
|
yes
|
no
|
|
|
|
|
tr_ship_inv_mov
|
yes
|
no
|
|
|
|
|
tr_ship_id
|
yes
|
no
|
|
∗
|
tr_trnbr
|
yes
|
tr_domain
|
yes
|
no
|
|
|
|
|
tr_trnbr
|
yes
|
no
|
|
|
tr_type
|
no
|
tr_domain
|
yes
|
no
|
|
|
|
|
tr_type
|
yes
|
no
|
|
|
|
|
tr_effdate
|
yes
|
no
|
|
|
tr_vend_lot
|
no
|
tr_domain
|
yes
|
no
|
|
|
|
|
tr_vend_lot
|
yes
|
no
|
|
|
Field Name
|
Label
|
Col-Label
|
Format
|
Dec
|
|
|
oid_tx2d_det
|
|
|
>>>>>>>>>>>>>>>>>>>>>>>>>>>9.9<<<<<<<<<
|
10
|
|
|
tx2d__chr01
|
|
|
x(8)
|
|
|
|
tx2d__chr02
|
|
|
x(8)
|
|
|
|
tx2d__dec01
|
|
|
->>>,>>>,>>9.99
|
10
|
|
|
tx2d__dec02
|
|
|
->>>,>>>,>>9.99
|
10
|
|
|
tx2d__dte01
|
|
|
99/99/99
|
|
|
|
tx2d__log01
|
|
|
yes/no
|
|
|
|
tx2d__qad01
|
|
|
x(8)
|
|
|
|
tx2d__qad02
|
|
|
x(8)
|
|
|
|
tx2d__qad03
|
|
|
yes/no
|
|
|
|
tx2d__qad04
|
|
|
->>>,>>>,>>9.99
|
10
|
|
|
tx2d__qad05
|
|
|
99/99/99
|
|
|
|
tx2d__qadd01[3]
|
|
|
->>>,>>>,>>9.99<
|
10
|
|
|
tx2d__qadd02[10]
|
|
|
->>>,>>>,>>9.99<
|
10
|
|
|
tx2d_abs_ret_amt
|
Base Absorbed/Retained
|
|
->>,>>>,>>9.99
|
10
|
|
|
tx2d_by_line
|
Tax-By-Line
|
By!Line
|
yes/no
|
|
|
|
tx2d_carrier
|
Carrier
|
|
x(8)
|
|
|
|
tx2d_cur_abs_ret_amt
|
Absorbed/Retained
|
|
->>,>>>,>>9.99
|
10
|
|
|
tx2d_cur_nontax_amt
|
Non-taxable
|
|
->>,>>>,>>9.99
|
10
|
|
|
tx2d_cur_recov_amt
|
Recoverable
|
|
->>,>>>,>>9.99
|
10
|
|
|
tx2d_cur_tax_amt
|
Tax
|
|
->>,>>>,>>9.99
|
10
|
|
|
tx2d_curr
|
Currency
|
Cur
|
x(3)
|
|
|
|
tx2d_domain
|
Domain
|
|
x(8)
|
|
|
|
tx2d_edited
|
Edited
|
Ed
|
yes/no
|
|
|
|
tx2d_effdate
|
Tax Date
|
|
99/99/99
|
|
|
|
tx2d_ent_abs_ret_amt
|
Entity Absorbed/Retained
|
|
->>,>>>,>>9.99
|
10
|
|
|
tx2d_ent_nontax_amt
|
Entity Non-Taxable
|
|
->>,>>>,>>9.99
|
10
|
|
|
tx2d_ent_recov_amt
|
Entity Recoverable
|
|
->>,>>>,>>9.99
|
10
|
|
|
tx2d_ent_tax_amt
|
Entity Tax
|
|
->>,>>>,>>9.99
|
10
|
|
|
tx2d_line
|
Line
|
|
>>>>>>>9
|
|
|
|
tx2d_line_site_ent
|
Line Site Entity
|
|
x(4)
|
|
|
|
tx2d_markup_amt
|
Markup tax amount
|
|
->,>>>,>>>,>>9.99
|
10
|
|
|
tx2d_markup_pct
|
Markup percentage
|
|
->>9.99<<%
|
10
|
|
|
tx2d_mgmt_abs_ret_amt
|
Statutory Absorbed/Retained
|
|
->>,>>>,>>9.99
|
10
|
|
|
tx2d_mgmt_nontax_amt
|
Statutory Non-Taxable
|
|
->>,>>>,>>9.99
|
10
|
|
|
tx2d_mgmt_recov_amt
|
Statutory Recoverable
|
|
->>,>>>,>>9.99
|
10
|
|
|
tx2d_mgmt_tax_amt
|
Statutory Tax
|
|
->>,>>>,>>9.99
|
10
|
|
|
tx2d_nbr
|
Number
|
|
x(8)
|
|
|
|
tx2d_nontax_amt
|
Base Non-Taxable
|
|
->>,>>>,>>9.99
|
10
|
|
|
tx2d_posted_date
|
Posted Date
|
Post!Date
|
99/99/99
|
|
|
|
tx2d_rcpt_tax_point
|
Accrue Tax at Receipt
|
|
yes/no
|
|
|
|
tx2d_recov_amt
|
Base Recoverable
|
|
->>,>>>,>>9.99
|
10
|
|
|
tx2d_ref
|
Reference
|
Ref
|
x(42)
|
|
|
|
tx2d_tax_amt
|
Base Tax
|
|
->>,>>>,>>9.99
|
10
|
|
|
tx2d_tax_code
|
Tax Code
|
|
x(8)
|
|
|
|
tx2d_tax_env
|
Tax Environment
|
Tax!Env
|
x(16)
|
|
|
|
tx2d_tax_in
|
Tax In
|
Tax!In
|
yes/no
|
|
|
|
tx2d_tax_pct
|
Tax Percentage
|
Tax %
|
->>9.99<<%
|
10
|
|
|
tx2d_tax_type
|
Tax Type
|
|
x(16)
|
|
|
|
tx2d_tax_usage
|
Tax Usage
|
Tax!Usage
|
x(8)
|
|
|
|
tx2d_taxable_amt
|
Base Taxable
|
|
->>,>>>,>>9.99
|
10
|
|
|
tx2d_taxc
|
Tax Class
|
Tax!Class
|
x(3)
|
|
|
|
tx2d_totamt
|
Total Amount
|
|
->>,>>>,>>9.99
|
10
|
|
|
tx2d_tottax
|
Taxable Sales
|
Taxable!Sales
|
->>,>>>,>>9.99
|
10
|
|
|
tx2d_tr_type
|
Transaction Type
|
TT
|
x(2)
|
|
|
|
tx2d_trans_ent
|
Transaction Entity
|
|
x(4)
|
|
|
|
tx2d_trl
|
Trailer
|
Trl
|
x(18)
|
|
|
|
tx2d_usage_tax_point
|
Accrue Tax At Usage
|
Accrue Tax!At Usage
|
yes/no
|
|
|
|
tx2d_user1
|
Ufld1
|
|
x(8)
|
|
|
|
tx2d_user2
|
Ufld2
|
|
x(8)
|
|
|
|
tx2d_zone_from
|
Ship-From Tax Zone
|
|
x(16)
|
|
|
|
tx2d_zone_to
|
Ship-To Tax Zone
|
|
x(16)
|
|
|
|
Index-Name
|
Uni
|
Field-Name
|
Asc
|
Abbr
|
|
|
oid_tx2d_det
|
yes
|
oid_tx2d_det
|
yes
|
no
|
|
|
tx2d_carrier
|
no
|
tx2d_domain
|
yes
|
no
|
|
|
|
|
tx2d_carrier
|
yes
|
no
|
|
∗
|
tx2d_ref_nbr
|
yes
|
tx2d_domain
|
yes
|
no
|
|
|
|
|
tx2d_ref
|
yes
|
no
|
|
|
|
|
tx2d_nbr
|
yes
|
no
|
|
|
|
|
tx2d_line
|
yes
|
no
|
|
|
|
|
tx2d_trl
|
yes
|
no
|
|
|
|
|
tx2d_tr_type
|
yes
|
no
|
|
|
|
|
tx2d_tax_code
|
yes
|
no
|
|
|
tx2d_tax_code
|
no
|
tx2d_domain
|
yes
|
no
|
|
|
|
|
tx2d_tax_code
|
yes
|
no
|
|
|
Field Name
|
Label
|
Col-Label
|
Format
|
Dec
|
|
|
oid_tx2_mstr
|
|
|
>>>>>>>>>>>>>>>>>>>>>>>>>>>9.9<<<<<<<<<
|
10
|
|
|
tx2__chr01
|
|
|
x(8)
|
|
|
|
tx2__chr02
|
|
|
x(8)
|
|
|
|
tx2__dec01
|
|
|
->>>,>>>,>>9.99
|
10
|
|
|
tx2__dec02
|
|
|
->>>,>>>,>>9.99
|
10
|
|
|
tx2__dte01
|
|
|
99/99/99
|
|
|
|
tx2__log01
|
|
|
yes/no
|
|
|
|
tx2__qad01
|
|
|
x(8)
|
|
|
|
tx2__qad02
|
|
|
x(8)
|
|
|
|
tx2__qad03
|
|
|
yes/no
|
|
|
|
tx2__qad04
|
|
|
->>>,>>>,>>9.99
|
10
|
|
|
tx2__qad05
|
|
|
99/99/99
|
|
|
|
tx2__qadc01[2]
|
|
|
x(8)
|
|
|
|
tx2__qadc02[2]
|
|
|
x(4)
|
|
|
|
tx2_ab_cn_tx_grp
|
Absorbed CN Tax Group
|
Abs CN Tax Grp
|
x(20)
|
|
|
|
tx2_ab_inv_tx_grp
|
Absorbed Inv Tax Group
|
Abs Inv Tax Grp
|
x(20)
|
|
|
|
tx2_ap_acct
|
AP Tax Account
|
|
x(8)
|
|
|
|
tx2_ap_cc
|
CC
|
|
x(4)
|
|
|
|
tx2_ap_cn_acct
|
AP Tax CN Account
|
AP Tax CN Acct
|
x(8)
|
|
|
|
tx2_ap_cn_sub
|
AP Tax CN Sub-Account
|
AP Tax CN Sub-Acct
|
x(8)
|
|
|
|
tx2_ap_dis_acct
|
AP Discount Account
|
AP Disc Acct
|
x(8)
|
|
|
|
tx2_ap_dis_sub
|
AP Discount Sub-Account
|
AP Disc Sub-Acct
|
x(8)
|
|
|
|
tx2_ap_disc_acct
|
AP Discount Account
|
|
x(8)
|
|
|
|
tx2_ap_disc_cc
|
CC
|
|
x(4)
|
|
|
|
tx2_ap_disc_sub
|
AP Discount Sub-Account
|
Sub-Acct
|
x(8)
|
|
|
|
tx2_ap_sub
|
AP Tax Sub-Account
|
Sub-Acct
|
x(8)
|
|
|
|
tx2_apr_acct
|
AP Retained Tax Account
|
|
x(8)
|
|
|
|
tx2_apr_cc
|
CC
|
|
x(4)
|
|
|
|
tx2_apr_cn_acct
|
AP Tax Ret CN Account
|
AP Tax Ret CN Acct
|
x(8)
|
|
|
|
tx2_apr_cn_sub
|
AP Tax Ret CN Sub-Account
|
AP Tax Ret CN Sub-Acct
|
x(8)
|
|
|
|
tx2_apr_sub
|
AP Retained Tax sub
|
Sub-Acct
|
x(8)
|
|
|
|
tx2_apr_use
|
|
|
yes/no
|
|
|
|
tx2_ar_acct
|
AR Sales Tax Account
|
|
x(8)
|
|
|
|
tx2_ar_cc
|
CC
|
|
x(4)
|
|
|
|
tx2_ar_cn_acct
|
Sales Tax CN Account
|
Sales Tax CN Acct
|
x(8)
|
|
|
|
tx2_ar_cn_sub
|
Sales Tax CN Sub-Account
|
Sales Tax CN Sub-Acct
|
x(8)
|
|
|
|
tx2_ar_dis_acct
|
AR Discount Account
|
AR Disc Acct
|
x(8)
|
|
|
|
tx2_ar_dis_sub
|
AR Discount Sub-Account
|
AR Disc Sub-Acct
|
x(8)
|
|
|
|
tx2_ar_disc_acct
|
AR Discount Account
|
|
x(8)
|
|
|
|
tx2_ar_disc_cc
|
CC
|
|
x(4)
|
|
|
|
tx2_ar_disc_sub
|
AR Discount Sub-Account
|
Sub-Acct
|
x(8)
|
|
|
|
tx2_ar_sub
|
AR Sales Tax Sub-Acct
|
Sub-Acct
|
x(8)
|
|
|
|
tx2_ara_acct
|
AR Absorbed Tax Account
|
|
x(8)
|
|
|
|
tx2_ara_cc
|
CC
|
|
x(4)
|
|
|
|
tx2_ara_cn_acct
|
Sales Tax Abs CN Acct
|
|
x(8)
|
|
|
|
tx2_ara_cn_sub
|
Sales Tax Abs CN Sub-Acct
|
|
x(8)
|
|
|
|
tx2_ara_sub
|
AR Absorbed Tax Sub
|
Sub-Acct
|
x(8)
|
|
|
|
tx2_ara_use
|
|
|
yes/no
|
|
|
|
tx2_base
|
Taxable Base Code
|
Tax Base
|
x(8)
|
|
|
|
tx2_by_line
|
Tax-By-Line
|
By!Line
|
yes/no
|
|
|
|
tx2_cmtindx
|
Comment Index
|
Comment
|
>>>>>>>9
|
|
|
|
tx2_cn_tx_grp
|
Customer Credit Note Tax Group
|
Cust CN Tax Grp
|
x(20)
|
|
|
|
tx2_cr_voc_tx_grp
|
Supplier CN Tax Group
|
Sup CN Tax Grp
|
x(20)
|
|
|
|
tx2_cst_code
|
CST Code
|
|
x(2)
|
|
|
|
tx2_curr
|
Currency
|
Cur
|
x(3)
|
|
|
|
tx2_daybookset
|
Daybook Set
|
Dybk Set
|
x(8)
|
|
|
|
tx2_desc
|
Description
|
|
x(24)
|
|
|
|
tx2_dltx_cn_acct
|
Delayed Tax CN Account
|
Delayed Tax CN Acct
|
x(8)
|
|
|
|
tx2_dltx_cn_sub
|
Delayed Tax CN Sub-Account
|
Delayed Tax CN Sub-Acct
|
x(8)
|
|
|
|
tx2_dltx_inv_acct
|
Delayed Tax Invoice Account
|
Delayed Tax Inv Acct
|
x(8)
|
|
|
|
tx2_dltx_inv_sub
|
Delayed Tax Invoice Sub-Account
|
Delayed Tax Inv Sub-Acct
|
x(8)
|
|
|
|
tx2_domain
|
Domain
|
|
x(8)
|
|
|
|
tx2_ec_process_work
|
EC Process Work
|
|
yes/no
|
|
|
|
tx2_ec_sales_list
|
EC Sales List
|
|
yes/no
|
|
|
|
tx2_effdate
|
Effective
|
|
99/99/99
|
|
|
|
tx2_exp_date
|
Expiration Date
|
Expiration!Date
|
99/99/99
|
|
|
|
tx2_group
|
Tax Group
|
|
x(8)
|
|
|
|
tx2_inv_disc
|
Discount Tax at Invoice
|
Disc!Inv
|
yes/no
|
|
|
|
tx2_inv_tx_grp
|
Customer Invoice Tax Group
|
Cust Inv Tax Grp
|
x(20)
|
|
|
|
tx2_markup_pct
|
Markup Percent
|
|
->>9.99<<%
|
10
|
|
|
tx2_max
|
Maximum Taxable Amount
|
Max Amount
|
>>>,>>>,>>>,>>9.99<
|
10
|
|
|
tx2_method
|
Tax Method
|
Tax!Meth
|
x(2)
|
|
|
|
tx2_min
|
Minimum Taxable Amount
|
Min Taxable
|
>>>,>>>,>>>,>>9.99<
|
10
|
|
|
tx2_mod_date
|
Modified Date
|
Mod Date
|
99/99/99
|
|
|
|
tx2_pct_recv
|
Percent Recoverable
|
Pct Recov
|
->>9.99<<%
|
10
|
|
|
tx2_pmt_disc
|
Discount Tax at Payment
|
Disc!Pmt
|
yes/no
|
|
|
|
tx2_pt_taxc
|
Item Tax Class
|
TxC
|
x(3)
|
|
|
|
tx2_rcpt_tax_point
|
Accrue Tax at Receipt
|
|
yes/no
|
|
|
|
tx2_register
|
Tax Register
|
|
x(2)
|
|
|
|
tx2_ret_cr_voc_tx_grp
|
Retained CN Tax Group
|
Retained CN Tax Grp
|
x(20)
|
|
|
|
tx2_ret_voc_tx_grp
|
Retained Invoice Tax Group
|
Retained Inv Tax Grp
|
x(20)
|
|
|
|
tx2_reverse_charge
|
Domestic Reverse Charge
|
|
yes/no
|
|
|
|
tx2_stx_acct
|
Suspended Tax Account
|
|
x(8)
|
|
|
|
tx2_stx_cc
|
CC
|
|
x(4)
|
|
|
|
tx2_stx_cn_acct
|
Suspended Tax CN Account
|
Susp Tax CN Acct
|
x(8)
|
|
|
|
tx2_stx_cn_sub
|
Suspended Tax CN Sub-Account
|
Susp Tax CN Sub-Acct
|
x(8)
|
|
|
|
tx2_stx_dltx_use
|
Suspended/Delayed Taxes
|
Sus/Del!Taxes
|
yes/no
|
|
|
|
tx2_stx_inv_acct
|
Suspended Tax Inv Account
|
Susp Tax Inv Acct
|
x(8)
|
|
|
|
tx2_stx_inv_sub
|
Suspended Tax Inv Sub-Account
|
Susp Tax Inv Sub-Acct
|
x(8)
|
|
|
|
tx2_stx_sub
|
Suspended Tax Sub Account
|
Sub-Acct
|
x(8)
|
|
|
|
tx2_tax_code
|
Tax Code
|
|
x(8)
|
|
|
|
tx2_tax_in
|
Allow Tax Included
|
|
yes/no
|
|
|
|
tx2_tax_pct
|
Tax Rate
|
|
->>9.99<<%
|
10
|
|
|
tx2_tax_type
|
Tax Type
|
|
x(16)
|
|
|
|
tx2_tax_usage
|
Tax Usage
|
TaxUsage
|
x(8)
|
|
|
|
tx2_trl_taxable
|
Tax Trailer Amounts
|
Tax Trl
|
yes/no
|
|
|
|
tx2_update_tax
|
Update Tax Allowed
|
Upd!Tax
|
yes/no
|
|
|
|
tx2_usage_tax_point
|
Accrue Tax At Usage
|
Accrue Tax!At Usage
|
yes/no
|
|
|
|
tx2_user1
|
Ufld1
|
|
x(8)
|
|
|
|
tx2_user2
|
Ufld2
|
|
x(8)
|
|
|
|
tx2_userid
|
User ID
|
|
x(8)
|
|
|
|
tx2_voc_tx_grp
|
Supplier Invoice Tax Group
|
Sup Inv Tax Grp
|
x(20)
|
|
|
|
tx2_wht_amt_for_100
|
Amount for Withhold 100% VAT
|
|
->>,>>9.99<
|
10
|
|
|
tx2_wht_fix_amt
|
Fixed Amount
|
|
->>,>>9.99<
|
10
|
|
|
tx2_wht_gi_jurisdiction_code
|
Gross Income Jurisdiction
|
|
x(8)
|
|
|
|
tx2_wht_magnetic_file
|
Include in Files
|
|
yes/no
|
|
|
|
tx2_wht_min_amt
|
Minimum Withhold Amount
|
|
->>,>>9.99<
|
10
|
|
|
tx2_wht_min_nontax_amt
|
Minimum Non-taxable Amount
|
|
->>,>>9.99<
|
10
|
|
|
tx2_wht_regime_code
|
Regime Code
|
|
x(8)
|
|
|
|
tx2_wht_rg738_operation_code
|
Operation Code RG738
|
|
x(8)
|
|
|
|
tx2_wht_rg738_tax_code
|
Tax Code RG738
|
|
x(8)
|
|
|
|
Index-Name
|
Uni
|
Field-Name
|
Asc
|
Abbr
|
|
|
oid_tx2_mstr
|
yes
|
oid_tx2_mstr
|
yes
|
no
|
|
|
tx2_register
|
no
|
tx2_domain
|
yes
|
no
|
|
|
|
|
tx2_register
|
yes
|
no
|
|
∗
|
tx2_tax_code
|
yes
|
tx2_domain
|
yes
|
no
|
|
|
|
|
tx2_tax_code
|
yes
|
no
|
|
|
tx2_type_taxc
|
yes
|
tx2_domain
|
yes
|
no
|
|
|
|
|
tx2_tax_type
|
yes
|
no
|
|
|
|
|
tx2_pt_taxc
|
yes
|
no
|
|
|
|
|
tx2_tax_usage
|
yes
|
no
|
|
|
|
|
tx2_effdate
|
yes
|
no
|