|
|
Field Name
|
Label
|
Col-Label
|
Format
|
Dec
|
|
|
aaa_id
|
|
|
>9
|
|
|
|
Index-Name
|
Uni
|
Field-Name
|
Asc
|
Abbr
|
|
∗
|
aaa_idx
|
yes
|
aaa_id
|
yes
|
no
|
|
|
Field Name
|
Label
|
Col-Label
|
Format
|
Dec
|
|
|
abscc__qadc01
|
|
|
x(24)
|
|
|
|
abscc__qadc02
|
|
|
x(24)
|
|
|
|
abscc_abs_id
|
ID
|
|
x(20)
|
|
|
|
abscc_abs_shipfrom
|
Ship From
|
|
x(8)
|
|
|
|
abscc_charge_type
|
Charge Type
|
Charge!Type
|
x(8)
|
|
|
|
abscc_confirmed
|
Confirmed
|
|
yes/no
|
|
|
|
abscc_cont_price
|
Price
|
|
->>>>,>>>,>>9.99<<<
|
10
|
|
|
abscc_container
|
Container
|
|
x(18)
|
|
|
|
abscc_domain
|
Domain
|
|
x(8)
|
|
|
|
abscc_fr_class
|
Freight Class
|
|
x(8)
|
|
|
|
abscc_inv_nbr
|
Invoice Number
|
|
x(22)
|
|
|
|
abscc_inv_post
|
Posted
|
|
yes/no
|
|
|
|
abscc_mod_date
|
Modified Date
|
Mod Date
|
99/99/99
|
|
|
|
abscc_mod_userid
|
User ID
|
|
x(8)
|
|
|
|
abscc_ord_line
|
SO Line
|
SO!Line
|
>>9
|
|
|
|
abscc_order
|
Sales Order
|
|
x(8)
|
|
|
|
abscc_project
|
Project
|
|
x(8)
|
|
|
|
abscc_qty
|
Quantity
|
|
->>,>>>,>>9.9<<<<<<<<<
|
10
|
|
|
abscc_ref
|
Reference
|
|
x(24)
|
|
|
|
abscc_ship_wt
|
Ship Weight
|
|
->>,>>>,>>9.9<<<<<<<<<
|
10
|
|
|
abscc_ship_wt_um
|
Ship Weight UM
|
UM
|
x(2)
|
|
|
|
abscc_shipto
|
Ship-To/Dock
|
|
x(8)
|
|
|
|
abscc_shp_date
|
Ship Date
|
|
99/99/99
|
|
|
|
abscc_sls_acct
|
Sales Acct
|
Account
|
x(8)
|
|
|
|
abscc_sls_cc
|
Sales Cost Ctr
|
CC
|
x(4)
|
|
|
|
abscc_sls_sub
|
Sales Sub-Acct
|
Sub-Acct
|
x(8)
|
|
|
|
abscc_taxable
|
Taxable
|
Tax
|
yes/no
|
|
|
|
abscc_taxc
|
Tax Class
|
TxC
|
x(3)
|
|
|
|
abscc_userc01
|
User Field Character 1
|
|
x(24)
|
|
|
|
abscc_userc02
|
User Field Character 2
|
|
x(24)
|
|
|
|
oid_abscc_det
|
|
|
>>>>>>>>>>>>>>>>>>>>>>>>>>>9.9<<<<<<<<<
|
10
|
|
|
Index-Name
|
Uni
|
Field-Name
|
Asc
|
Abbr
|
|
∗
|
abscc_id
|
yes
|
abscc_domain
|
yes
|
no
|
|
|
|
|
abscc_abs_id
|
yes
|
no
|
|
|
|
|
abscc_abs_shipfrom
|
yes
|
no
|
|
|
abscc_inv_nbr
|
no
|
abscc_domain
|
yes
|
no
|
|
|
|
|
abscc_inv_nbr
|
yes
|
no
|
|
|
|
|
abscc_order
|
yes
|
no
|
|
|
abscc_ordln
|
no
|
abscc_domain
|
yes
|
no
|
|
|
|
|
abscc_order
|
yes
|
no
|
|
|
|
|
abscc_ord_line
|
yes
|
no
|
|
|
|
|
abscc_inv_post
|
yes
|
no
|
|
|
abscc_shipto
|
no
|
abscc_domain
|
yes
|
no
|
|
|
|
|
abscc_shipto
|
yes
|
no
|
|
|
|
|
abscc_shp_date
|
yes
|
no
|
|
|
|
|
abscc_container
|
yes
|
no
|
|
|
oid_abscc_det
|
yes
|
oid_abscc_det
|
yes
|
no
|
|
|
Field Name
|
Label
|
Col-Label
|
Format
|
Dec
|
|
|
absc__qadc01
|
|
|
x(8)
|
|
|
|
absc_abs_id
|
ID
|
|
x(20)
|
|
|
|
absc_carrier
|
Carrier
|
|
x(8)
|
|
|
|
absc_domain
|
Domain
|
|
x(8)
|
|
|
|
absc_seq
|
Seq
|
|
>>9
|
|
|
|
absc_user1
|
Ufld1
|
|
x(8)
|
|
|
|
absc_user2
|
Ufld2
|
|
x(8)
|
|
|
|
oid_absc_det
|
|
|
>>>>>>>>>>>>>>>>>>>>>>>>>>>9.9<<<<<<<<<
|
10
|
|
|
Index-Name
|
Uni
|
Field-Name
|
Asc
|
Abbr
|
|
∗
|
absc_abs_id
|
yes
|
absc_domain
|
yes
|
no
|
|
|
|
|
absc_abs_id
|
yes
|
no
|
|
|
|
|
absc_seq
|
yes
|
no
|
|
|
absc_carrier
|
no
|
absc_domain
|
yes
|
no
|
|
|
|
|
absc_carrier
|
yes
|
no
|
|
|
oid_absc_det
|
yes
|
oid_absc_det
|
yes
|
no
|
|
|
Field Name
|
Label
|
Col-Label
|
Format
|
Dec
|
|
|
absd__qadc02
|
|
|
x(24)
|
|
|
|
absd__qadc03
|
|
|
x(24)
|
|
|
|
absd_abs_fld_name
|
Shipper Field Name
|
|
x(32)
|
|
|
|
absd_abs_id
|
ID
|
|
x(20)
|
|
|
|
absd_domain
|
Domain
|
|
x(8)
|
|
|
|
absd_fld_name
|
Field Name
|
|
X(30)
|
|
|
|
absd_fld_prompt
|
Prompt for Value
|
|
yes/no
|
|
|
|
absd_fld_seq
|
Field Sequence
|
Seq
|
>>9
|
|
|
|
absd_fld_value
|
Field Value
|
|
X(30)
|
|
|
|
absd_mod_date
|
Modified Date
|
Mod Date
|
99/99/99
|
|
|
|
absd_mod_userid
|
User ID
|
|
x(8)
|
|
|
|
absd_shipfrom
|
Ship From
|
|
x(8)
|
|
|
|
absd_shipper_id
|
|
|
x(24)
|
|
|
|
absd_userc01
|
User Field Character 1
|
|
x(24)
|
|
|
|
absd_validate
|
Validate
|
|
x(24)
|
|
|
|
oid_absd_det
|
|
|
>>>>>>>>>>>>>>>>>>>>>>>>>>>9.9<<<<<<<<<
|
10
|
|
|
Index-Name
|
Uni
|
Field-Name
|
Asc
|
Abbr
|
|
∗
|
absd_fld_name
|
yes
|
absd_domain
|
yes
|
no
|
|
|
|
|
absd_shipfrom
|
yes
|
no
|
|
|
|
|
absd_abs_id
|
yes
|
no
|
|
|
|
|
absd_fld_name
|
yes
|
no
|
|
|
absd_shipper_id
|
no
|
absd_domain
|
yes
|
no
|
|
|
|
|
absd_shipfrom
|
yes
|
no
|
|
|
|
|
absd_shipper_id
|
yes
|
no
|
|
|
|
|
absd_fld_name
|
yes
|
no
|
|
|
oid_absd_det
|
yes
|
oid_absd_det
|
yes
|
no
|
|
|
Field Name
|
Label
|
Col-Label
|
Format
|
Dec
|
|
|
absi__qadc01
|
|
|
x(24)
|
|
|
|
absi__qadc02
|
|
|
x(24)
|
|
|
|
absi_abs_id
|
Shipper ID
|
Shipper
|
x(20)
|
|
|
|
absi_carrier_ref2
|
Carrier Reference 2
|
|
x(20)
|
|
|
|
absi_contents
|
Contents
|
|
x(60)
|
|
|
|
absi_domain
|
Domain
|
|
x(8)
|
|
|
|
absi_due_date
|
Due Date
|
Due
|
99/99/99
|
|
|
|
absi_mod_date
|
Modified Date
|
Mod Date
|
99/99/99
|
|
|
|
absi_mod_userid
|
User ID
|
|
x(8)
|
|
|
|
absi_origin
|
Origin
|
|
x(30)
|
|
|
|
absi_port_arrive
|
Port of Arrival
|
|
x(30)
|
|
|
|
absi_port_depart
|
Port of Departure
|
|
x(30)
|
|
|
|
absi_shipfrom
|
Ship-From
|
|
x(8)
|
|
|
|
absi_user1
|
User Field Character 1
|
|
x(24)
|
|
|
|
absi_user2
|
User Field Character 2
|
|
x(24)
|
|
|
|
absi_voyage
|
Voyage
|
|
x(20)
|
|
|
|
oid_absi_mstr
|
|
|
>>>>>>>>>>>>>>>>>>>>>>>>>>>9.9<<<<<<<<<
|
10
|
|
|
Index-Name
|
Uni
|
Field-Name
|
Asc
|
Abbr
|
|
∗
|
absi_abs_id
|
yes
|
absi_domain
|
yes
|
no
|
|
|
|
|
absi_shipfrom
|
yes
|
no
|
|
|
|
|
absi_abs_id
|
yes
|
no
|
|
|
oid_absi_mstr
|
yes
|
oid_absi_mstr
|
yes
|
no
|
|
|
Field Name
|
Label
|
Col-Label
|
Format
|
Dec
|
|
|
absl__qadc01
|
|
|
x(24)
|
|
|
|
absl__qadc02
|
|
|
x(24)
|
|
|
|
absl_abs_id
|
ID
|
|
x(20)
|
|
|
|
absl_abs_shipfrom
|
Ship From
|
|
x(8)
|
|
|
|
absl_acct
|
Trailer Acct
|
Account
|
x(8)
|
|
|
|
absl_cc
|
Trailer CC
|
CC
|
x(4)
|
|
|
|
absl_charge_type
|
Charge Type
|
Charge!Type
|
x(8)
|
|
|
|
absl_confirmed
|
Confirmed
|
|
yes/no
|
|
|
|
absl_domain
|
Domain
|
|
x(8)
|
|
|
|
absl_ext_price
|
Extended Charge
|
|
->>>>,>>>,>>9.99<<<
|
10
|
|
|
absl_inv_nbr
|
Invoice Number
|
|
x(22)
|
|
|
|
absl_inv_post
|
Posted
|
|
yes/no
|
|
|
|
absl_lc_amt
|
Charge
|
|
->>>>,>>>,>>9.99<<<
|
10
|
|
|
absl_lc_line
|
Charge Line
|
Ln
|
>>9
|
|
|
|
absl_mod_date
|
Modified Date
|
Mod Date
|
99/99/99
|
|
|
|
absl_mod_userid
|
User ID
|
|
x(8)
|
|
|
|
absl_ord_line
|
SO Line
|
SO!Line
|
>>9
|
|
|
|
absl_order
|
Sales Order
|
|
x(8)
|
|
|
|
absl_project
|
Project
|
|
x(8)
|
|
|
|
absl_ref
|
Reference
|
|
x(24)
|
|
|
|
absl_sub
|
Trailer Sub-Acct
|
Sub-Acct
|
x(8)
|
|
|
|
absl_taxable
|
Taxable
|
|
yes/no
|
|
|
|
absl_taxc
|
Tax Class
|
TxC
|
x(3)
|
|
|
|
absl_trl_code
|
Trailer Code
|
Code
|
x(2)
|
|
|
|
absl_userc01
|
User Field Character 1
|
|
x(24)
|
|
|
|
absl_userc02
|
User Field Character 2
|
|
x(24)
|
|
|
|
oid_absl_det
|
|
|
>>>>>>>>>>>>>>>>>>>>>>>>>>>9.9<<<<<<<<<
|
10
|
|
|
Index-Name
|
Uni
|
Field-Name
|
Asc
|
Abbr
|
|
∗
|
absl_abs_id
|
yes
|
absl_domain
|
yes
|
no
|
|
|
|
|
absl_abs_id
|
yes
|
no
|
|
|
|
|
absl_abs_shipfrom
|
yes
|
no
|
|
|
|
|
absl_order
|
yes
|
no
|
|
|
|
|
absl_ord_line
|
yes
|
no
|
|
|
|
|
absl_lc_line
|
yes
|
no
|
|
|
absl_order
|
no
|
absl_domain
|
yes
|
no
|
|
|
|
|
absl_order
|
yes
|
no
|
|
|
|
|
absl_ord_line
|
yes
|
no
|
|
|
|
|
absl_inv_post
|
yes
|
no
|
|
|
oid_absl_det
|
yes
|
oid_absl_det
|
yes
|
no
|
|
|
Field Name
|
Label
|
Col-Label
|
Format
|
Dec
|
|
|
abspli__qadc01
|
|
|
x(24)
|
|
|
|
abspli__qadc02
|
|
|
x(24)
|
|
|
|
abspli_abs_id
|
Shipper ID
|
Shipper ID
|
x(20)
|
|
|
|
abspli_domain
|
Domain
|
|
x(8)
|
|
|
|
abspli_mod_date
|
Modified Date
|
Mod Date
|
99/99/99
|
|
|
|
abspli_mod_userid
|
User ID
|
|
x(8)
|
|
|
|
abspli_pli_keyid
|
Key ID
|
|
>>>>>>>>>
|
|
|
|
abspli_supplier
|
Supplier
|
|
x(8)
|
|
|
|
abspli_user1
|
User Field Character 1
|
|
x(24)
|
|
|
|
abspli_user2
|
User Field Character 2
|
|
x(24)
|
|
|
|
oid_abspli_ref
|
|
|
>>>>>>>>>>>>>>>>>>>>>>>>>>>9.9<<<<<<<<<
|
10
|
|
|
Index-Name
|
Uni
|
Field-Name
|
Asc
|
Abbr
|
|
∗
|
abspli_primary
|
yes
|
abspli_domain
|
yes
|
no
|
|
|
|
|
abspli_supplier
|
yes
|
no
|
|
|
|
|
abspli_abs_id
|
yes
|
no
|
|
|
|
|
abspli_pli_keyid
|
yes
|
no
|
|
|
oid_abspli_ref
|
yes
|
oid_abspli_ref
|
yes
|
no
|
|
|
Field Name
|
Label
|
Col-Label
|
Format
|
Dec
|
|
|
absp__qadc01
|
QAD Character Field 1
|
|
x(24)
|
|
|
|
absp__qadc02
|
QAD Character Field 2
|
|
x(24)
|
|
|
|
absp_mod_date
|
Modified Date
|
Mod Date
|
99/99/99
|
|
|
|
absp_mod_userid
|
User ID
|
|
x(8)
|
|
|
|
absp_po_nbr
|
Purchase Order
|
Order
|
x(8)
|
|
|
|
absp_pod_line
|
Line
|
|
>>9
|
|
|
|
absp_rcpt_qty
|
Receipt Qty
|
|
->,>>>,>>9.9<<<<<<<<
|
10
|
|
|
absp_user1
|
User Field Character 1
|
|
x(24)
|
|
|
|
absp_user2
|
User Field Character 2
|
|
x(24)
|
|
|
|
absp_wo_lot
|
Cum Order ID
|
Cum ID
|
x(8)
|
|
|
|
oid_abs_mstr
|
|
|
>>>>>>>>>>>>>>>>>>>>>>>>>>>9.9<<<<<<<<<
|
10
|
|
|
oid_absp_det
|
|
|
>>>>>>>>>>>>>>>>>>>>>>>>>>>9.9<<<<<<<<<
|
10
|
|
|
Index-Name
|
Uni
|
Field-Name
|
Asc
|
Abbr
|
|
∗
|
absp_oid_abs_mstr
|
yes
|
oid_abs_mstr
|
yes
|
no
|
|
|
|
|
absp_po_nbr
|
yes
|
no
|
|
|
|
|
absp_pod_line
|
yes
|
no
|
|
|
oid_absp_det
|
yes
|
oid_absp_det
|
yes
|
no
|
|
|
Field Name
|
Label
|
Col-Label
|
Format
|
Dec
|
|
|
absr__qadc01
|
|
|
x(8)
|
|
|
|
absr_cnfrmd
|
Confirmed
|
|
yes/no
|
|
|
|
absr_date
|
Date
|
|
99/99/99
|
|
|
|
absr_domain
|
Domain
|
|
x(8)
|
|
|
|
absr_id
|
Id
|
|
x(8)
|
|
|
|
absr_interval
|
Interval
|
|
x(1)
|
|
|
|
absr_line
|
Line
|
Ln
|
>>9
|
|
|
|
absr_nbr
|
Order
|
Sls Order
|
x(8)
|
|
|
|
absr_qty
|
Qty Pegged
|
|
>,>>>,>>9.9<<<<
|
10
|
|
|
absr_reference
|
Reference
|
|
x(24)
|
|
|
|
absr_rlse_id
|
Release ID
|
|
x(30)
|
|
|
|
absr_ship_id
|
ID
|
|
x(8)
|
|
|
|
absr_shipfrom
|
Ship-from Id
|
|
x(8)
|
|
|
|
absr_time
|
Time
|
|
99:99
|
|
|
|
absr_type
|
Schedule Type
|
|
>9
|
|
|
|
absr_user1
|
Ufld1
|
|
x(8)
|
|
|
|
absr_user2
|
Ufld2
|
|
x(8)
|
|
|
|
oid_absr_det
|
|
|
>>>>>>>>>>>>>>>>>>>>>>>>>>>9.9<<<<<<<<<
|
10
|
|
|
Index-Name
|
Uni
|
Field-Name
|
Asc
|
Abbr
|
|
∗
|
absr_dtl
|
yes
|
absr_domain
|
yes
|
no
|
|
|
|
|
absr_shipfrom
|
yes
|
no
|
|
|
|
|
absr_id
|
yes
|
no
|
|
|
|
|
absr_type
|
yes
|
no
|
|
|
|
|
absr_nbr
|
yes
|
no
|
|
|
|
|
absr_line
|
yes
|
no
|
|
|
|
|
absr_rlse_id
|
yes
|
no
|
|
|
|
|
absr_date
|
yes
|
no
|
|
|
|
|
absr_time
|
yes
|
no
|
|
|
|
|
absr_interval
|
yes
|
no
|
|
|
|
|
absr_reference
|
yes
|
no
|
|
|
absr_nbr
|
no
|
absr_domain
|
yes
|
no
|
|
|
|
|
absr_cnfrmd
|
yes
|
no
|
|
|
|
|
absr_type
|
yes
|
no
|
|
|
|
|
absr_nbr
|
yes
|
no
|
|
|
|
|
absr_line
|
yes
|
no
|
|
|
|
|
absr_rlse_id
|
yes
|
no
|
|
|
|
|
absr_date
|
yes
|
no
|
|
|
|
|
absr_time
|
yes
|
no
|
|
|
|
|
absr_interval
|
yes
|
no
|
|
|
|
|
absr_reference
|
yes
|
no
|
|
|
oid_absr_det
|
yes
|
oid_absr_det
|
yes
|
no
|
|
|
Field Name
|
Label
|
Col-Label
|
Format
|
Dec
|
|
|
abssc__qadc01
|
|
|
x(24)
|
|
|
|
abssc__qadc02
|
|
|
x(24)
|
|
|
|
abssc_abs_id
|
Shipper ID
|
|
x(20)
|
|
|
|
abssc_abs_item
|
Item
|
|
x(18)
|
|
|
|
abssc_abs_shipfrom
|
Ship-From
|
|
x(8)
|
|
|
|
abssc_container_id
|
Container ID
|
|
x(8)
|
|
|
|
abssc_create_date
|
Create Date
|
|
99/99/99
|
|
|
|
abssc_create_time
|
Create Time
|
|
>>>>>>>9
|
|
|
|
abssc_create_userid
|
User ID
|
|
x(8)
|
|
|
|
abssc_domain
|
Domain
|
|
x(8)
|
|
|
|
abssc_fld_value
|
Field Value
|
|
x(30)
|
|
|
|
abssc_flddesc
|
Field Description
|
|
x(40)
|
|
|
|
abssc_fldname
|
Fieldname
|
|
x(30)
|
|
|
|
abssc_line
|
Line
|
|
x(8)
|
|
|
|
abssc_line_abs_id
|
Line Abs Id
|
|
x(20)
|
|
|
|
abssc_mod_date
|
Modified Date
|
Mod Date
|
99/99/99
|
|
|
|
abssc_mod_userid
|
User ID
|
|
x(8)
|
|
|
|
abssc_msglevel
|
Message Level
|
|
9
|
|
|
|
abssc_msgnum
|
Message Number
|
|
>>>>9
|
|
|
|
abssc_order
|
Order
|
|
x(8)
|
|
|
|
abssc_resolved
|
Resolved
|
|
yes/no
|
|
|
|
abssc_resolved_date
|
Resolved Date
|
|
99/99/99
|
|
|
|
abssc_resolved_time
|
Resolved Time
|
|
>>>>>>>9
|
|
|
|
abssc_resolved_userid
|
User ID
|
|
x(8)
|
|
|
|
abssc_shphv_val_arg1
|
Message Argument
|
|
x(22)
|
|
|
|
abssc_shphvpv_location
|
Location
|
|
x(22)
|
|
|
|
abssc_user1
|
User Field Character 1
|
|
x(24)
|
|
|
|
abssc_user2
|
User Field Character 2
|
|
x(24)
|
|
|
|
abssc_val_msg1
|
Message
|
|
x(45)
|
|
|
|
abssc_val_msg2
|
Message
|
|
x(75)
|
|
|
|
oid_abssc_det
|
|
|
>>>>>>>>>>>>>>>>>>>>>>>>>>>9.9<<<<<<<<<
|
10
|
|
|
oid_shphv_det
|
|
|
>>>>>>>>>>>>>>>>>>>>>>>>>>>9.9<<<<<<<<<
|
10
|
|
|
Index-Name
|
Uni
|
Field-Name
|
Asc
|
Abbr
|
|
∗
|
abssc_abs_id
|
yes
|
abssc_domain
|
yes
|
no
|
|
|
|
|
abssc_abs_shipfrom
|
yes
|
no
|
|
|
|
|
abssc_abs_id
|
yes
|
no
|
|
|
|
|
abssc_line_abs_id
|
yes
|
no
|
|
|
|
|
abssc_fldname
|
yes
|
no
|
|
|
|
|
abssc_msgnum
|
yes
|
no
|
|
|
|
|
abssc_msglevel
|
yes
|
no
|
|
|
abssc_resolved
|
no
|
abssc_domain
|
yes
|
no
|
|
|
|
|
abssc_resolved
|
yes
|
no
|
|
|
|
|
abssc_abs_shipfrom
|
yes
|
no
|
|
|
|
|
abssc_create_date
|
yes
|
no
|
|
|
|
|
abssc_abs_id
|
yes
|
no
|
|
|
oid_abssc_det
|
yes
|
oid_abssc_det
|
yes
|
no
|
|
|
Field Name
|
Label
|
Col-Label
|
Format
|
Dec
|
|
|
abssi__qadc01
|
|
|
x(24)
|
|
|
|
abssi__qadc02
|
|
|
x(24)
|
|
|
|
abssi_abs_id
|
Shipper ID
|
|
x(20)
|
|
|
|
abssi_certificate
|
Shipment Certificate
|
|
x(16)
|
|
|
|
abssi_create_date
|
Creation Date
|
|
99/99/9999
|
|
|
|
abssi_create_time
|
Creation Time
|
|
x(10)
|
|
|
|
abssi_curr_signature
|
Signature Current Shipment
|
|
x(256)
|
|
|
|
abssi_domain
|
Domain
|
|
x(8)
|
|
|
|
abssi_key
|
Certification Key
|
|
x(128)
|
|
|
|
abssi_mod_date
|
Modified date
|
Mod Date
|
99/99/99
|
|
|
|
abssi_mod_userid
|
User ID
|
|
x(8)
|
|
|
|
abssi_prev_signature
|
Signature Previous Shipment
|
|
x(256)
|
|
|
|
abssi_short_signature
|
Short Signature
|
|
x(4)
|
|
|
|
abssi_status
|
Status
|
|
x(10)
|
|
|
|
abssi_user1
|
User Field Character 1
|
|
x(24)
|
|
|
|
abssi_user2
|
User Field Character 2
|
|
x(24)
|
|
|
|
abssi_version
|
Version
|
|
x(8)
|
|
|
|
oid_abs_mstr
|
|
|
>>>>>>>>>>>>>>>>>>>>>>>>>>>9.9<<<<<<<<<
|
10
|
|
|
oid_abssi_det
|
|
|
>>>>>>>>>>>>>>>>>>>>>>>>>>>9.9<<<<<<<<<
|
10
|
|
|
Index-Name
|
Uni
|
Field-Name
|
Asc
|
Abbr
|
|
∗
|
oid_abs_mstr
|
no
|
oid_abs_mstr
|
yes
|
no
|
|
|
oid_abssi_det
|
yes
|
oid_abssi_det
|
yes
|
no
|
|
|
Field Name
|
Label
|
Col-Label
|
Format
|
Dec
|
|
|
abss__qadc01
|
|
|
x(8)
|
|
|
|
abss__qadc02
|
|
|
x(8)
|
|
|
|
abss__qadd01
|
|
|
->,>>>,>>9.9<<<<<<<<
|
10
|
|
|
abss__qadd02
|
|
|
->,>>>,>>9.9<<<<<<<<
|
10
|
|
|
abss__qadi01
|
|
|
->,>>>,>>9
|
|
|
|
abss__qadi02
|
|
|
->,>>>,>>9
|
|
|
|
abss__qadl01
|
|
|
yes/no
|
|
|
|
abss__qadl02
|
|
|
yes/no
|
|
|
|
abss__qadt01
|
|
|
99/99/99
|
|
|
|
abss__qadt02
|
|
|
99/99/99
|
|
|
|
abss_abs_id
|
ID
|
|
x(20)
|
|
|
|
abss_confirmed
|
Confirmed
|
|
yes/no
|
|
|
|
abss_cust_job
|
Customer Job
|
|
x(30)
|
|
|
|
abss_cust_ref
|
Customer Reference
|
|
x(30)
|
|
|
|
abss_cust_seq
|
Customer Sequence
|
|
x(30)
|
|
|
|
abss_date
|
Schedule Date
|
Date
|
99/99/99
|
|
|
|
abss_dock
|
Customer Dock
|
|
x(30)
|
|
|
|
abss_domain
|
Domain
|
|
x(8)
|
|
|
|
abss_invoice
|
Invoice
|
|
x(8)
|
|
|
|
abss_line
|
Line
|
|
>>9
|
|
|
|
abss_line_feed
|
Line Feed
|
|
x(30)
|
|
|
|
abss_mod_date
|
Modified Date
|
Mod Date
|
99/99/99
|
|
|
|
abss_mod_pgm
|
Last Program
|
|
x(8)
|
|
|
|
abss_mod_userid
|
User ID
|
|
x(8)
|
|
|
|
abss_order
|
Order
|
|
x(8)
|
|
|
|
abss_part
|
Item Number
|
|
x(18)
|
|
|
|
abss_qty
|
Quantity
|
|
>>,>>>,>>9.9<<<<<<<<<
|
10
|
|
|
abss_rlse_id
|
Release ID
|
|
x(30)
|
|
|
|
abss_ship_id
|
Ship ID
|
|
x(20)
|
|
|
|
abss_shipfrom
|
Ship-From
|
|
x(8)
|
|
|
|
abss_shipto
|
Ship-To
|
|
x(8)
|
|
|
|
abss_status
|
Status
|
|
x(8)
|
|
|
|
abss_time
|
Schedule Time
|
Time
|
99:99
|
|
|
|
abss_user1
|
Ufld1
|
|
x(8)
|
|
|
|
abss_user2
|
Ufld2
|
|
x(8)
|
|
|
|
oid_abss_det
|
|
|
>>>>>>>>>>>>>>>>>>>>>>>>>>>9.9<<<<<<<<<
|
10
|
|
|
Index-Name
|
Uni
|
Field-Name
|
Asc
|
Abbr
|
|
∗
|
abss_index1
|
yes
|
abss_domain
|
yes
|
no
|
|
|
|
|
abss_abs_id
|
yes
|
no
|
|
|
|
|
abss_shipfrom
|
yes
|
no
|
|
|
|
|
abss_shipto
|
yes
|
no
|
|
|
|
|
abss_rlse_id
|
yes
|
no
|
|
|
|
|
abss_cust_job
|
yes
|
no
|
|
|
|
|
abss_cust_seq
|
yes
|
no
|
|
|
|
|
abss_part
|
yes
|
no
|
|
|
|
|
abss_date
|
yes
|
no
|
|
|
|
|
abss_time
|
yes
|
no
|
|
|
|
|
abss_cust_ref
|
yes
|
no
|
|
|
|
|
abss_dock
|
yes
|
no
|
|
|
|
|
abss_line_feed
|
yes
|
no
|
|
|
abss_index2
|
no
|
abss_domain
|
yes
|
no
|
|
|
|
|
abss_shipfrom
|
yes
|
no
|
|
|
|
|
abss_shipto
|
yes
|
no
|
|
|
|
|
abss_rlse_id
|
yes
|
no
|
|
|
|
|
abss_cust_ref
|
yes
|
no
|
|
|
|
|
abss_part
|
yes
|
no
|
|
|
abss_index3
|
no
|
abss_domain
|
yes
|
no
|
|
|
|
|
abss_ship_id
|
yes
|
no
|
|
|
|
|
abss_part
|
yes
|
no
|
|
|
|
|
abss_cust_job
|
yes
|
no
|
|
|
|
|
abss_cust_seq
|
yes
|
no
|
|
|
abss_index4
|
no
|
abss_domain
|
yes
|
no
|
|
|
|
|
abss_ship_id
|
yes
|
no
|
|
|
|
|
abss_date
|
yes
|
no
|
|
|
|
|
abss_time
|
yes
|
no
|
|
|
|
|
abss_cust_job
|
yes
|
no
|
|
|
|
|
abss_cust_seq
|
yes
|
no
|
|
|
|
|
abss_part
|
yes
|
no
|
|
|
abss_index5
|
no
|
abss_domain
|
yes
|
no
|
|
|
|
|
abss_ship_id
|
yes
|
no
|
|
|
|
|
abss_order
|
yes
|
no
|
|
|
|
|
abss_line
|
yes
|
no
|
|
|
abss_index6
|
no
|
abss_domain
|
yes
|
no
|
|
|
|
|
abss_invoice
|
yes
|
no
|
|
|
|
|
abss_order
|
yes
|
no
|
|
|
|
|
abss_line
|
yes
|
no
|
|
|
abss_index7
|
no
|
abss_domain
|
yes
|
no
|
|
|
|
|
abss_invoice
|
yes
|
no
|
|
|
|
|
abss_cust_job
|
yes
|
no
|
|
|
|
|
abss_cust_seq
|
yes
|
no
|
|
|
|
|
abss_part
|
yes
|
no
|
|
|
oid_abss_det
|
yes
|
oid_abss_det
|
yes
|
no
|
|
|
Field Name
|
Label
|
Col-Label
|
Format
|
Dec
|
|
|
absw__qadc01
|
QAD Character Field 1
|
|
x(24)
|
|
|
|
absw__qadc02
|
QAD Character Field 2
|
|
x(24)
|
|
|
|
absw_lotser
|
Lot/Serial
|
|
x(18)
|
|
|
|
absw_mod_date
|
Modified Date
|
Mod Date
|
99/99/99
|
|
|
|
absw_mod_userid
|
User ID
|
|
x(8)
|
|
|
|
absw_rcpt_qty
|
Receipt Qty
|
|
>,>>>,>>9.9<<<<<<<<
|
10
|
|
|
absw_receipt_date
|
Receipt Date
|
|
99/99/99
|
|
|
|
absw_receipt_time
|
Arrive Time
|
|
>>>>>>>9
|
|
|
|
absw_ref
|
Reference
|
Ref
|
x(8)
|
|
|
|
absw_scrap_qty
|
Scrap Qty
|
|
>,>>>,>>9.9<<<<<<<<
|
10
|
|
|
absw_ship_qty
|
Quantity Shipped
|
Quantity!Shipped
|
>,>>>,>>9.9<<<<<<<<
|
10
|
|
|
absw_user1
|
User Field Character 1
|
|
x(24)
|
|
|
|
absw_user2
|
User Field Character 2
|
|
x(24)
|
|
|
|
oid_abs_mstr
|
|
|
>>>>>>>>>>>>>>>>>>>>>>>>>>>9.9<<<<<<<<<
|
10
|
|
|
oid_absw_det
|
|
|
>>>>>>>>>>>>>>>>>>>>>>>>>>>9.9<<<<<<<<<
|
10
|
|
|
Index-Name
|
Uni
|
Field-Name
|
Asc
|
Abbr
|
|
∗
|
absw_oid_abs_mstr
|
yes
|
oid_abs_mstr
|
yes
|
no
|
|
|
|
|
absw_lotser
|
yes
|
no
|
|
|
|
|
absw_ref
|
yes
|
no
|
|
|
oid_absw_det
|
yes
|
oid_absw_det
|
yes
|
no
|
|
|
Field Name
|
Label
|
Col-Label
|
Format
|
Dec
|
|
|
absx__qadc01
|
QAD Character Field 1
|
|
x(24)
|
|
|
|
absx__qadc02
|
QAD Character Field 2
|
|
x(24)
|
|
|
|
absx_comment
|
Comment Index
|
|
>>>>>>>>
|
|
|
|
absx_complete
|
Close Sub Shipper
|
Close!Sub Shipper
|
yes/no
|
|
|
|
absx_domain
|
Domain
|
|
x(8)
|
|
|
|
absx_lotser
|
Lot/Serial
|
|
x(18)
|
|
|
|
absx_mod_date
|
Modified Date
|
Mod Date
|
99/99/99
|
|
|
|
absx_mod_userid
|
User ID
|
|
x(8)
|
|
|
|
absx_part
|
Item Number
|
|
x(18)
|
|
|
|
absx_po_nbr
|
Purchase Order
|
Order
|
x(8)
|
|
|
|
absx_po_shipper
|
PO Shipper
|
|
x(20)
|
|
|
|
absx_pod_line
|
Line
|
|
>>9
|
|
|
|
absx_qty_to_receive
|
Qty To Receive
|
|
->,>>>,>>9.9<<<<<<<<
|
10
|
|
|
absx_qty_to_scrap
|
Qty To Scrap
|
|
->,>>>,>>9.9<<<<<<<<
|
10
|
|
|
absx_ref
|
Reference
|
Ref
|
x(8)
|
|
|
|
absx_return
|
Return
|
|
yes/no
|
|
|
|
absx_user1
|
User Field Character 1
|
|
x(24)
|
|
|
|
absx_user2
|
User Field Character 2
|
|
x(24)
|
|
|
|
oid_abs_subcontract
|
|
|
>>>>>>>>>>>>>>>>>>>>>>>>>>>9.9<<<<<<<<<
|
10
|
|
|
oid_absx_det
|
|
|
>>>>>>>>>>>>>>>>>>>>>>>>>>>9.9<<<<<<<<<
|
10
|
|
|
Index-Name
|
Uni
|
Field-Name
|
Asc
|
Abbr
|
|
∗
|
absx_oid_abs_mstr
|
yes
|
oid_abs_subcontract
|
yes
|
no
|
|
|
|
|
absx_domain
|
yes
|
no
|
|
|
|
|
absx_part
|
yes
|
no
|
|
|
|
|
absx_lotser
|
yes
|
no
|
|
|
|
|
absx_ref
|
yes
|
no
|
|
|
|
|
absx_po_shipper
|
yes
|
no
|
|
|
absx_po
|
no
|
absx_domain
|
yes
|
no
|
|
|
|
|
absx_po_shipper
|
yes
|
no
|
|
|
|
|
absx_po_nbr
|
yes
|
no
|
|
|
|
|
absx_pod_line
|
yes
|
no
|
|
|
|
|
absx_lotser
|
yes
|
no
|
|
|
|
|
absx_ref
|
yes
|
no
|
|
|
oid_absx_det
|
yes
|
oid_absx_det
|
yes
|
no
|
|
|
Field Name
|
Label
|
Col-Label
|
Format
|
Dec
|
|
|
abs__chr01
|
|
|
x(8)
|
|
|
|
abs__chr02
|
|
|
x(8)
|
|
|
|
abs__chr03
|
|
|
x(8)
|
|
|
|
abs__chr04
|
|
|
x(8)
|
|
|
|
abs__chr05
|
|
|
x(8)
|
|
|
|
abs__chr06
|
|
|
x(8)
|
|
|
|
abs__chr07
|
|
|
x(8)
|
|
|
|
abs__chr08
|
|
|
x(8)
|
|
|
|
abs__chr09
|
|
|
x(8)
|
|
|
|
abs__chr10
|
|
|
x(8)
|
|
|
|
abs__dec01
|
|
|
>>>,>>>,>>9.99
|
10
|
|
|
abs__dec02
|
|
|
>>>,>>>,>>9.99
|
10
|
|
|
abs__dec03
|
|
|
>>>,>>>,>>9.99
|
10
|
|
|
abs__dec04
|
|
|
>>>,>>>,>>9.99
|
10
|
|
|
abs__dec05
|
|
|
>>>,>>>,>>9.99
|
10
|
|
|
abs__dec06
|
|
|
>>>,>>>,>>9.99
|
10
|
|
|
abs__dec07
|
|
|
>>>,>>>,>>9.99
|
10
|
|
|
abs__dec08
|
|
|
>>>,>>>,>>9.99
|
10
|
|
|
abs__dec09
|
|
|
>>>,>>>,>>9.99
|
10
|
|
|
abs__dec10
|
|
|
>>>,>>>,>>9.99
|
10
|
|
|
abs__qad01
|
|
|
x(8)
|
|
|
|
abs__qad02
|
|
|
x(8)
|
|
|
|
abs__qad03
|
|
|
x(8)
|
|
|
|
abs__qad04
|
|
|
x(8)
|
|
|
|
abs__qad05
|
|
|
x(8)
|
|
|
|
abs__qad06
|
|
|
x(8)
|
|
|
|
abs__qad07
|
|
|
x(8)
|
|
|
|
abs__qad08
|
|
|
x(8)
|
|
|
|
abs__qad09
|
|
|
x(8)
|
|
|
|
abs__qad10
|
|
|
x(8)
|
|
|
|
abs__qadc01
|
|
|
x(8)
|
|
|
|
abs__qadc02
|
|
|
x(24)
|
|
|
|
abs__qadc03
|
|
|
x(24)
|
|
|
|
abs__qadd01
|
|
|
>,>>>,>>9.9<<<<<<<<
|
10
|
|
|
abs__qadi01
|
|
|
->>>>>>>9
|
|
|
|
abs__qadl01
|
|
|
yes/no
|
|
|
|
abs__qadt01
|
|
|
99/99/99
|
|
|
|
abs_acct
|
Account
|
Acct
|
x(8)
|
|
|
|
abs_act_fcst
|
Act Frt Cost
|
|
>>>>,>>>,>>9.99
|
10
|
|
|
abs_act_qty
|
Actual Qty
|
|
->>,>>>,>>9.9<<<<<<<<<
|
10
|
|
|
abs_apr_date
|
Approval Date
|
|
99/99/99
|
|
|
|
abs_apr_time
|
Approval Time
|
|
>>>>>>>9
|
|
|
|
abs_apr_userid
|
Approved By
|
|
x(8)
|
|
|
|
abs_arr_date
|
Arrive Date
|
|
99/99/99
|
|
|
|
abs_arr_time
|
Arrive Time
|
|
>>>>>>>9
|
|
|
|
abs_asn_crt_date
|
ASN Create Date
|
|
99/99/99
|
|
|
|
abs_asn_crt_time
|
ASN Create Time
|
|
>>>>>>>9
|
|
|
|
abs_bom_code
|
BOM/Formula
|
|
x(18)
|
|
|
|
abs_bulk_qty
|
Actual Bulk Qty
|
|
->>,>>>,>>9.9<<<<<<<<<
|
10
|
|
|
abs_cancel_date
|
Cancel Date
|
|
99/99/99
|
|
|
|
abs_canceled
|
Canceled
|
|
Yes/No
|
|
|
|
abs_cc
|
Cost Center
|
CC
|
x(4)
|
|
|
|
abs_charge_type
|
Charge Type
|
Charge!Type
|
x(8)
|
|
|
|
abs_cmtindx
|
Comment Index
|
|
>>>>>>>9
|
|
|
|
abs_combined_invoice
|
Combined Invoice
|
|
yes/no
|
|
|
|
abs_complete
|
Complete
|
|
yes/no
|
|
|
|
abs_cons_ship
|
Consolidate
|
|
x(8)
|
|
|
|
abs_consigned_return
|
Consigned Return
|
|
yes/no
|
|
|
|
abs_crt_date
|
Create Date
|
|
99/99/99
|
|
|
|
abs_crt_time
|
Create Time
|
|
>>>>>>>9
|
|
|
|
abs_cum_qty
|
Cum Ship Qty
|
|
>,>>>,>>9.9<<<<<<<<
|
10
|
|
|
abs_cust_ref
|
Customer Ref
|
|
x(24)
|
|
|
|
abs_dataset
|
Data Set
|
|
x(12)
|
|
|
|
abs_desc
|
Description
|
|
x(48)
|
|
|
|
abs_dim_um
|
Dimensions UM
|
|
x(2)
|
|
|
|
abs_doc_data[5]
|
|
|
x(8)
|
|
|
|
abs_domain
|
Domain
|
|
x(8)
|
|
|
|
abs_eff_date
|
Effective
|
|
99/99/99
|
|
|
|
abs_est_fcst
|
Est Frt Cost
|
|
>>>>,>>>,>>9.99
|
10
|
|
|
abs_export_batch
|
Batch
|
|
>>>>>>>>9
|
|
|
|
abs_export_date
|
Export Date
|
|
99/99/99
|
|
|
|
abs_export_time
|
Export Time
|
|
>>>>>>>9
|
|
|
|
abs_fa_lot
|
Final Assembly ID
|
ID
|
x(8)
|
|
|
|
abs_format
|
Document Format
|
Format
|
x(8)
|
|
|
|
abs_fr_class
|
Frt Class
|
|
x(8)
|
|
|
|
abs_fr_curr
|
Currency
|
|
x(3)
|
|
|
|
abs_gwt
|
Gross Weight
|
|
>,>>>,>>9.9<<<<<<<<
|
10
|
|
|
abs_id
|
Id
|
|
x(20)
|
|
|
|
abs_inv_mov
|
Inventory Movement Code
|
Inv Mov
|
x(8)
|
|
|
|
abs_inv_nbr
|
Invoice Number
|
|
x(22)
|
|
|
|
abs_item
|
Container Item
|
|
x(18)
|
|
|
|
abs_lang
|
Language
|
|
x(2)
|
|
|
|
abs_line
|
Order Line
|
|
x(8)
|
|
|
|
abs_loc
|
Location
|
|
x(8)
|
|
|
|
abs_lotser
|
Lot/Serial
|
|
x(18)
|
|
|
|
abs_master_id
|
Master Bill ID
|
|
x(20)
|
|
|
|
abs_master_shipfrom
|
Master Bill Ship-From
|
MBOL!ShipFrom
|
x(8)
|
|
|
|
abs_nr_id
|
Sequence ID
|
|
x(8)
|
|
|
|
abs_nwt
|
Net Weight
|
|
>,>>>,>>9.9<<<<<<<<
|
10
|
|
|
abs_order
|
Order
|
|
x(8)
|
|
|
|
abs_par_id
|
Parent ID
|
|
x(24)
|
|
|
|
abs_preship_id
|
Pre-Shipper Number
|
|
x(20)
|
|
|
|
abs_preship_nr_id
|
Pre-Shipper Sequence ID
|
|
x(8)
|
|
|
|
abs_price
|
Price
|
|
->>>>,>>>,>>9.99<<<
|
10
|
|
|
abs_production_line
|
Production Line
|
Line
|
x(8)
|
|
|
|
abs_proj
|
Project
|
|
x(8)
|
|
|
|
abs_qty
|
Qty To Ship
|
|
>,>>>,>>9.9<<<<<<<<
|
10
|
|
|
abs_rcpt_qty
|
Receipt Qty
|
|
>,>>>,>>9.9<<<<<<<<
|
10
|
|
|
abs_ref
|
Ref
|
|
x(8)
|
|
|
|
abs_routing
|
Routing Code
|
|
x(18)
|
|
|
|
abs_scrap_qty
|
Scrap Qty
|
|
>,>>>,>>9.9<<<<<<<<
|
10
|
|
|
abs_ship_qty
|
Quantity Shipped
|
|
>,>>>,>>9.9<<<<<<<<
|
10
|
|
|
abs_ship_type
|
Ship Type
|
T
|
x(1)
|
|
|
|
abs_shipfrom
|
Ship-from Id
|
|
x(8)
|
|
|
|
abs_shipto
|
Ship-to Id
|
|
x(8)
|
|
|
|
abs_shp_date
|
Ship Date
|
|
99/99/99
|
|
|
|
abs_shp_time
|
Ship Time
|
|
>>>>>>>9
|
|
|
|
abs_site
|
Site
|
|
x(8)
|
|
|
|
abs_status
|
Status
|
|
x(8)
|
|
|
|
abs_sub
|
Sub-Account
|
Sub-Acct
|
x(8)
|
|
|
|
abs_tax_env
|
Tax Environment
|
|
x(16)
|
|
|
|
abs_tax_in
|
Tax In
|
|
yes/no
|
|
|
|
abs_tax_usage
|
Tax Usage
|
|
x(8)
|
|
|
|
abs_taxable
|
Taxable
|
|
yes/no
|
|
|
|
abs_taxc
|
Tax Class
|
|
x(3)
|
|
|
|
abs_timezone
|
Time Zone
|
|
x(2)
|
|
|
|
abs_trl_cmtindx
|
Trailer Comments
|
|
>>>>>>>9
|
|
|
|
abs_type
|
Type
|
|
x(1)
|
|
|
|
abs_user1
|
Ufld1
|
|
x(8)
|
|
|
|
abs_user2
|
Ufld2
|
|
x(8)
|
|
|
|
abs_vend_lot
|
Supplier Lot
|
|
x(18)
|
|
|
|
abs_vol
|
Volume
|
|
>,>>>,>>9.9<<<<<<<<
|
10
|
|
|
abs_vol_um
|
Volume UM
|
|
x(2)
|
|
|
|
abs_wt_um
|
Weight UM
|
|
x(2)
|
|
|
|
oid_abs_mstr
|
|
|
>>>>>>>>>>>>>>>>>>>>>>>>>>>9.9<<<<<<<<<
|
10
|
|
|
oid_lgdd_det
|
|
|
>>>>>>>>>>>>>>>>>>>>>>>>>>>9.9<<<<<<<<<
|
10
|
|
|
Index-Name
|
Uni
|
Field-Name
|
Asc
|
Abbr
|
|
|
abs_export_batch
|
no
|
abs_domain
|
yes
|
no
|
|
|
|
|
abs_export_batch
|
yes
|
no
|
|
|
abs_format
|
no
|
abs_domain
|
yes
|
no
|
|
|
|
|
abs_format
|
yes
|
no
|
|
∗
|
abs_id
|
yes
|
abs_domain
|
yes
|
no
|
|
|
|
|
abs_shipfrom
|
yes
|
no
|
|
|
|
|
abs_id
|
yes
|
no
|
|
|
abs_inv_mov
|
no
|
abs_domain
|
yes
|
no
|
|
|
|
|
abs_inv_mov
|
yes
|
no
|
|
|
abs_inv_nbr
|
no
|
abs_domain
|
yes
|
no
|
|
|
|
|
abs_inv_nbr
|
yes
|
no
|
|
|
|
|
abs_shipfrom
|
yes
|
no
|
|
|
|
|
abs_id
|
yes
|
no
|
|
|
abs_item
|
no
|
abs_domain
|
yes
|
no
|
|
|
|
|
abs_item
|
yes
|
no
|
|
|
|
|
abs_shipfrom
|
yes
|
no
|
|
|
abs_master_id
|
no
|
abs_domain
|
yes
|
no
|
|
|
|
|
abs_master_id
|
yes
|
no
|
|
|
|
|
abs_master_shipfrom
|
yes
|
no
|
|
|
|
|
abs_shipfrom
|
yes
|
no
|
|
|
abs_order
|
no
|
abs_domain
|
yes
|
no
|
|
|
|
|
abs_order
|
yes
|
no
|
|
|
abs_par_id
|
yes
|
abs_domain
|
yes
|
no
|
|
|
|
|
abs_shipfrom
|
yes
|
no
|
|
|
|
|
abs_par_id
|
yes
|
no
|
|
|
|
|
abs_id
|
yes
|
no
|
|
|
abs_shipto
|
yes
|
abs_domain
|
yes
|
no
|
|
|
|
|
abs_shipfrom
|
yes
|
no
|
|
|
|
|
abs_shipto
|
yes
|
no
|
|
|
|
|
abs_id
|
yes
|
no
|
|
|
oid_abs_mstr
|
yes
|
oid_abs_mstr
|
yes
|
no
|
|
|
oid_lgdd_det
|
no
|
oid_lgdd_det
|
yes
|
no
|
|
|
Field Name
|
Label
|
Col-Label
|
Format
|
Dec
|
|
|
AcctIF_ID
|
Record ID
|
|
-99999999999
|
|
|
|
AcctIFCode
|
Code
|
|
x(20)
|
|
|
|
AcctIFExportFileName
|
Export File Name
|
|
x(40)
|
|
|
|
AcctIFIsExport
|
Export
|
|
yes/no
|
|
|
|
AcctIFLastExportDate
|
Last Export Date
|
|
99/99/9999
|
|
|
|
AcctIFName
|
Report Name
|
|
x(40)
|
|
|
|
AcctIFStatus
|
Status
|
|
x(40)
|
|
|
|
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
|
|
|
|
Usr_ID
|
User Name
|
|
-99999999999
|
|
|
|
Index-Name
|
Uni
|
Field-Name
|
Asc
|
Abbr
|
|
∗
|
Prim
|
yes
|
AcctIF_ID
|
yes
|
no
|
|
|
UniqueIdx
|
yes
|
AcctIFCode
|
yes
|
no
|
|
|
UsrIdx
|
no
|
Usr_ID
|
yes
|
no
|
|
|
Field Name
|
Label
|
Col-Label
|
Format
|
Dec
|
|
|
AcctIFFilter_ID
|
Record ID
|
|
-99999999999
|
|
|
|
AcctIFFilterAcctBookNo
|
Accounting Book No
|
Book No
|
x(40)
|
|
|
|
AcctIFFilterAcctFromDate
|
Measure1 from Date
|
|
99/99/9999
|
|
|
|
AcctIFFilterAcctFromDate2
|
Measure2 from Date
|
|
99/99/9999
|
|
|
|
AcctIFFilterAcctLevel
|
Account Code Structure
|
Acc Code Structure
|
x(40)
|
|
|
|
AcctIFFilterAcctToDate
|
Measure1 to Date
|
|
99/99/9999
|
|
|
|
AcctIFFilterAcctToDate2
|
Measure2 to Date
|
|
99/99/9999
|
|
|
|
AcctIFFilterAltCOALevel
|
Alternate COA Level
|
|
->,>>>,>>9
|
|
|
|
AcctIFFilterBudgetLevel
|
Budget Level
|
|
9
|
|
|
|
AcctIFFilterCOACrossRef
|
COA Cross Reference
|
|
x(20)
|
|
|
|
AcctIFFilterFiscalYear
|
Fiscal Year
|
|
x(4)
|
|
|
|
AcctIFFilterIndustry
|
Industry
|
|
x(40)
|
|
|
|
AcctIFFilterLayerCode
|
Layer Code
|
|
x(200)
|
|
|
|
AcctIFFilterOrgCode
|
Organization Code
|
Org Code
|
x(40)
|
|
|
|
AcctIFFilterStructCodeBS
|
Balance Sheet Structure Code
|
Balance Sheet
|
x(40)
|
|
|
|
AcctIFFilterStructCodeIS
|
Income statement Structure Code
|
Income Statement
|
x(40)
|
|
|
|
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
|
|
∗
|
Prim
|
yes
|
AcctIFFilter_ID
|
yes
|
no
|
|
|
UniqueIdx
|
yes
|
AcctIFFilterAcctLevel
|
yes
|
no
|
|
|
|
|
AcctIFFilterIndustry
|
yes
|
no
|
|
|
|
|
AcctIFFilterOrgCode
|
yes
|
no
|
|
|
|
|
AcctIFFilterFiscalYear
|
yes
|
no
|
|
|
|
|
AcctIFFilterAcctBookNo
|
yes
|
no
|
|
|
|
|
AcctIFFilterAcctFromDate
|
yes
|
no
|
|
|
|
|
AcctIFFilterAcctToDate
|
yes
|
no
|
|
|
|
|
AcctIFFilterAcctFromDate2
|
yes
|
no
|
|
|
|
|
AcctIFFilterAcctToDate2
|
yes
|
no
|
|
|
|
|
AcctIFFilterBudgetLevel
|
yes
|
no
|
|
|
|
|
AcctIFFilterStructCodeIS
|
yes
|
no
|
|
|
|
|
AcctIFFilterStructCodeBS
|
yes
|
no
|
|
|
|
|
AcctIFFilterLayerCode
|
yes
|
no
|
|
|
Field Name
|
Label
|
Col-Label
|
Format
|
Dec
|
|
|
acdf__qadc01
|
|
|
x(24)
|
|
|
|
acdf__qadd01
|
|
|
->>>>,>>>,>>9.99<<<<<<<<<
|
10
|
|
|
acdf__qadi01
|
|
|
->>>>>>>9
|
|
|
|
acdf__qadl01
|
|
|
yes/no
|
|
|
|
acdf__qadt01
|
|
|
99/99/99
|
|
|
|
acdf_acct
|
Account Number
|
Account
|
x(8)
|
|
|
|
acdf_cc
|
Cost Center
|
CC
|
x(4)
|
|
|
|
acdf_domain
|
Domain
|
|
x(8)
|
|
|
|
acdf_key1
|
|
|
x(20)
|
|
|
|
acdf_key2
|
|
|
x(8)
|
|
|
|
acdf_key3
|
|
|
x(8)
|
|
|
|
acdf_key4
|
|
|
x(8)
|
|
|
|
acdf_key5
|
|
|
x(8)
|
|
|
|
acdf_key6
|
|
|
x(8)
|
|
|
|
acdf_mod_date
|
Modified Date
|
Mod Date
|
99/99/99
|
|
|
|
acdf_mod_userid
|
User ID
|
|
x(8)
|
|
|
|
acdf_module
|
Module
|
|
x(2)
|
|
|
|
acdf_sub
|
Sub Account
|
Sub Acct
|
x(8)
|
|
|
|
acdf_type
|
Account Type
|
|
x(24)
|
|
|
|
acdf_userc01
|
User field Character 1
|
|
x(24)
|
|
|
|
acdf_userc02
|
User field character 2
|
|
x(24)
|
|
|
|
acdf_userd01
|
User field Decimal
|
|
->>>>,>>>,>>9.99<<<<<<<<<
|
10
|
|
|
acdf_useri01
|
User field integer
|
|
->>>>>>>9
|
|
|
|
acdf_userl01
|
User field logical
|
|
yes/no
|
|
|
|
acdf_usert01
|
User field Date
|
|
99/99/99
|
|
|
|
oid_acdf_mstr
|
|
|
>>>>>>>>>>>>>>>>>>>>>>>>>>>9.9<<<<<<<<<
|
10
|
|
|
Index-Name
|
Uni
|
Field-Name
|
Asc
|
Abbr
|
|
∗
|
acdf_index1
|
yes
|
acdf_domain
|
yes
|
no
|
|
|
|
|
acdf_module
|
yes
|
no
|
|
|
|
|
acdf_type
|
yes
|
no
|
|
|
|
|
acdf_key1
|
yes
|
no
|
|
|
|
|
acdf_key2
|
yes
|
no
|
|
|
|
|
acdf_key3
|
yes
|
no
|
|
|
|
|
acdf_key4
|
yes
|
no
|
|
|
|
|
acdf_key5
|
yes
|
no
|
|
|
|
|
acdf_key6
|
yes
|
no
|
|
|
oid_acdf_mstr
|
yes
|
oid_acdf_mstr
|
yes
|
no
|
|
|
Field Name
|
Label
|
Col-Label
|
Format
|
Dec
|
|
|
acld__qadc01
|
|
|
x(24)
|
|
|
|
acld__qadc02
|
|
|
x(24)
|
|
|
|
acld_active
|
Active
|
|
yes/no
|
|
|
|
acld_allow_mod
|
Allow Modification
|
Allow Mod
|
yes/no
|
|
|
|
acld_cat
|
Category
|
|
x(18)
|
|
|
|
acld_domain
|
Domain
|
|
x(8)
|
|
|
|
acld_label_term
|
Label Term
|
|
x(35)
|
|
|
|
acld_mod_date
|
Modified Date
|
Mod Date
|
99/99/99
|
|
|
|
acld_mod_userid
|
User ID
|
|
x(8)
|
|
|
|
acld_name
|
Attribute Name
|
|
x(32)
|
|
|
|
acld_req
|
Required
|
|
yes/no
|
|
|
|
acld_system
|
System
|
|
yes/no
|
|
|
|
acld_user1
|
User Field Character 1
|
|
x(24)
|
|
|
|
acld_user2
|
User Field Character 2
|
|
x(24)
|
|
|
|
oid_acld_det
|
|
|
>>>>>>>>>>>>>>>>>>>>>>>>>>>9.9<<<<<<<<<
|
10
|
|
|
Index-Name
|
Uni
|
Field-Name
|
Asc
|
Abbr
|
|
∗
|
acld_cat
|
yes
|
acld_cat
|
yes
|
no
|
|
|
|
|
acld_name
|
yes
|
no
|
|
|
|
|
acld_domain
|
yes
|
no
|
|
|
acld_name_domain
|
no
|
acld_name
|
yes
|
no
|
|
|
|
|
acld_domain
|
yes
|
no
|
|
|
oid_acld_det
|
yes
|
oid_acld_det
|
yes
|
no
|
|
|
Field Name
|
Label
|
Col-Label
|
Format
|
Dec
|
|
|
acm__qadc01
|
|
|
x(8)
|
|
|
|
acm_domain
|
Domain
|
|
x(8)
|
|
|
|
acm_method
|
Method
|
|
x(14)
|
|
|
|
acm_part
|
Base Process
|
|
x(18)
|
|
|
|
acm_prod_line
|
Product Line
|
|
x(4)
|
|
|
|
acm_site
|
Site
|
|
x(8)
|
|
|
|
acm_user1
|
Ufld1
|
|
x(8)
|
|
|
|
acm_user2
|
Ufld2
|
|
x(8)
|
|
|
|
oid_acm_mstr
|
|
|
>>>>>>>>>>>>>>>>>>>>>>>>>>>9.9<<<<<<<<<
|
10
|
|
|
Index-Name
|
Uni
|
Field-Name
|
Asc
|
Abbr
|
|
∗
|
acm_index
|
no
|
acm_domain
|
yes
|
no
|
|
|
|
|
acm_site
|
yes
|
no
|
|
|
|
|
acm_prod_line
|
yes
|
no
|
|
|
|
|
acm_part
|
yes
|
no
|
|
|
acm_unique
|
yes
|
acm_domain
|
yes
|
no
|
|
|
|
|
acm_site
|
yes
|
no
|
|
|
|
|
acm_prod_line
|
yes
|
no
|
|
|
|
|
acm_part
|
yes
|
no
|
|
|
|
|
acm_method
|
yes
|
no
|
|
|
oid_acm_mstr
|
yes
|
oid_acm_mstr
|
yes
|
no
|
|
|
Field Name
|
Label
|
Col-Label
|
Format
|
Dec
|
|
|
actf__qadc01
|
|
|
x(24)
|
|
|
|
actf__qadc02
|
|
|
x(24)
|
|
|
|
actf_acct_fldname
|
Account Field Name
|
Account!Field Name
|
x(32)
|
|
|
|
actf_cc_fldname
|
Cost Center Field Name
|
Cost Center!Field Name
|
x(32)
|
|
|
|
actf_exec
|
Execution File
|
Exec File
|
x(16)
|
|
|
|
actf_mod_date
|
Modified Date
|
Mod Date
|
99/99/99
|
|
|
|
actf_mod_userid
|
User ID
|
|
x(8)
|
|
|
|
actf_proj_fldname
|
Project Field Name
|
Project!Field Name
|
x(32)
|
|
|
|
actf_sub_fldname
|
Sub-Account Field Name
|
Sub-Account!Field Name
|
x(32)
|
|
|
|
actf_tblname
|
Table Name
|
Table!Name
|
x(16)
|
|
|
|
actf_user1
|
User Field Character 1
|
|
x(24)
|
|
|
|
actf_user2
|
User Field Character 2
|
|
x(24)
|
|
|
|
oid_actf_mstr
|
|
|
>>>>>>>>>>>>>>>>>>>>>>>>>>>9.9<<<<<<<<<
|
10
|
|
|
Index-Name
|
Uni
|
Field-Name
|
Asc
|
Abbr
|
|
∗
|
actf_tbl_acctfld
|
yes
|
actf_tblname
|
yes
|
no
|
|
|
|
|
actf_exec
|
yes
|
no
|
|
|
|
|
actf_acct_fldname
|
yes
|
no
|
|
|
oid_actf_mstr
|
yes
|
oid_actf_mstr
|
yes
|
no
|