|
|
Field Name
|
Label
|
Col-Label
|
Format
|
Dec
|
|
|
oid_rdf_mstr
|
|
|
>>>>>>>>>>>>>>>>>>>>>>>>>>>9.9<<<<<<<<<
|
10
|
|
|
rdf__chr01
|
|
|
x(8)
|
|
|
|
rdf__chr02
|
|
|
x(8)
|
|
|
|
rdf__chr03
|
|
|
x(8)
|
|
|
|
rdf__chr04
|
|
|
x(8)
|
|
|
|
rdf__chr05
|
|
|
x(8)
|
|
|
|
rdf__dec01
|
|
|
>>>,>>>,>>9.99
|
10
|
|
|
rdf__dec02
|
|
|
>>>,>>>,>>9.99
|
10
|
|
|
rdf__dte01
|
|
|
99/99/99
|
|
|
|
rdf__dte02
|
|
|
99/99/99
|
|
|
|
rdf__log01
|
|
|
yes/no
|
|
|
|
rdf__log02
|
|
|
yes/no
|
|
|
|
rdf__qadc01
|
QAD Character Field 1
|
|
X(8)
|
|
|
|
rdf__qadc02
|
QAD Character Field 2
|
|
X(8)
|
|
|
|
rdf__qadc03
|
QAD Character Field 3
|
|
X(8)
|
|
|
|
rdf__qade01
|
QAD Decimal Field 1
|
|
->>>,>>>,>>9.99<<
|
10
|
|
|
rdf__qade02
|
QAD Decimal Field 2
|
|
->>>,>>>,>>9.99<<
|
10
|
|
|
rdf__qadl01
|
Qad Logical Field 1
|
|
yes/no
|
|
|
|
rdf__qadl02
|
QAD Logical Field 2
|
|
yes/no
|
|
|
|
rdf__qadt01
|
QAD Date Field 1
|
|
99/99/99
|
|
|
|
rdf_addr
|
Address
|
|
x(8)
|
|
|
|
rdf_area
|
Area
|
|
x(8)
|
|
|
|
rdf_bom_code
|
Bill of Material
|
|
x(18)
|
|
|
|
rdf_ca_int_type
|
Work Code
|
WK Code
|
x(8)
|
|
|
|
rdf_ca_type
|
Call Type
|
|
x(8)
|
0
|
|
|
rdf_desc
|
Description
|
|
x(24)
|
|
|
|
rdf_domain
|
Domain
|
|
x(8)
|
|
|
|
rdf_email
|
Email Address
|
|
x(48)
|
|
|
|
rdf_es_nbr
|
Repair Sequence
|
Rep Seq
|
x(8)
|
0
|
|
|
rdf_fax
|
Fax
|
|
x(20)
|
|
|
|
rdf_group
|
Group
|
|
x(8)
|
|
|
|
rdf_mod_date
|
Modified Date
|
Mod Date
|
99/99/99
|
|
|
|
rdf_mod_userid
|
User ID
|
|
X(8)
|
|
|
|
rdf_notify
|
Notify
|
|
yes/no
|
|
|
|
rdf_part
|
Item
|
|
x(18)
|
|
|
|
rdf_prod_line
|
Prod Line
|
Line
|
x(4)
|
|
|
|
rdf_rep_loc
|
Repair Location
|
|
x(8)
|
|
|
|
rdf_rep_site
|
Repair Site
|
|
x(8)
|
|
|
|
rdf_repair_days
|
Repair Days
|
|
>,>>9.99
|
10
|
|
|
rdf_routing
|
Routing Code
|
|
x(18)
|
|
|
|
rdf_rrts_loc
|
Return from RTS Location
|
|
x(8)
|
|
|
|
rdf_rrts_site
|
Return from RTS Site
|
|
x(8)
|
|
|
|
rdf_rtn_loc
|
Return Location
|
|
x(8)
|
|
|
|
rdf_rtn_site
|
Return Site
|
|
x(8)
|
|
|
|
rdf_rts_loc
|
RTS Location
|
|
x(8)
|
|
|
|
rdf_rts_site
|
RTS Site
|
|
x(8)
|
|
|
|
rdf_scrap_loc
|
Scrap Location
|
|
x(8)
|
|
|
|
rdf_scrap_site
|
Scrap Site
|
|
x(8)
|
|
|
|
rdf_ship_time
|
Ship Days
|
|
>>9
|
10
|
|
|
rdf_spare_loc
|
Spares Location
|
|
x(8)
|
|
|
|
rdf_spare_site
|
Spares Site
|
|
x(8)
|
|
|
|
rdf_srtn_loc
|
Sales Return Location
|
|
x(8)
|
|
|
|
rdf_srtn_site
|
Sales Return Site
|
|
x(8)
|
|
|
|
rdf_svc_group
|
Service Group
|
Svc Grp
|
x(8)
|
0
|
|
|
rdf_transit_loc
|
Transit Location
|
|
x(8)
|
|
|
|
rdf_transit_site
|
Transit Site
|
|
x(8)
|
|
|
|
rdf_user1
|
Ufld1
|
|
x(8)
|
|
|
|
rdf_user2
|
Ufld2
|
|
x(8)
|
|
|
|
Index-Name
|
Uni
|
Field-Name
|
Asc
|
Abbr
|
|
|
oid_rdf_mstr
|
yes
|
oid_rdf_mstr
|
yes
|
no
|
|
∗
|
rdf_part
|
yes
|
rdf_domain
|
yes
|
no
|
|
|
|
|
rdf_prod_line
|
yes
|
no
|
|
|
|
|
rdf_svc_group
|
yes
|
no
|
|
|
|
|
rdf_ca_int_type
|
yes
|
no
|
|
|
|
|
rdf_part
|
yes
|
no
|
|
|
|
|
rdf_area
|
yes
|
no
|
|
|
Field Name
|
Label
|
Col-Label
|
Format
|
Dec
|
|
|
CustomCombo0
|
Custom Combo Field
|
|
x(20)
|
|
|
|
CustomCombo1
|
Custom Combo Field
|
|
x(20)
|
|
|
|
CustomCombo2
|
Custom Combo Field
|
|
x(20)
|
|
|
|
CustomCombo3
|
Custom Combo Field
|
|
x(20)
|
|
|
|
CustomCombo4
|
Custom Combo Field
|
|
x(20)
|
|
|
|
CustomCombo5
|
Custom Combo Field
|
|
x(20)
|
|
|
|
CustomCombo6
|
Custom Combo Field
|
|
x(20)
|
|
|
|
CustomCombo7
|
Custom Combo Field
|
|
x(20)
|
|
|
|
CustomCombo8
|
Custom Combo Field
|
|
x(20)
|
|
|
|
CustomCombo9
|
Custom Combo Field
|
|
x(20)
|
|
|
|
CustomDate0
|
Custom Date Field
|
|
99/99/9999
|
|
|
|
CustomDate1
|
Custom Date Field
|
|
99/99/9999
|
|
|
|
CustomDate2
|
Custom Date Field
|
|
99/99/9999
|
|
|
|
CustomDate3
|
Custom Date Field
|
|
99/99/9999
|
|
|
|
CustomDate4
|
Custom Date Field
|
|
99/99/9999
|
|
|
|
CustomDecimal0
|
Custom Decimal Field
|
|
->,>>>,>>9.99
|
4
|
|
|
CustomDecimal1
|
Custom Decimal Field
|
|
->,>>>,>>9.99
|
4
|
|
|
CustomDecimal2
|
Custom Decimal Field
|
|
->,>>>,>>9.99
|
4
|
|
|
CustomDecimal3
|
Custom Decimal Field
|
|
->,>>>,>>9.99
|
4
|
|
|
CustomDecimal4
|
Custom Decimal Field
|
|
->,>>>,>>9.99
|
4
|
|
|
CustomInteger0
|
Custom Integer Field
|
|
->,>>>,>>9
|
|
|
|
CustomInteger1
|
Custom Integer Field
|
|
->,>>>,>>9
|
|
|
|
CustomInteger2
|
Custom Integer Field
|
|
->,>>>,>>9
|
|
|
|
CustomInteger3
|
Custom Integer Field
|
|
->,>>>,>>9
|
|
|
|
CustomInteger4
|
Custom Integer Field
|
|
->,>>>,>>9
|
|
|
|
CustomLong0
|
Custom Long Field
|
|
x(255)
|
|
|
|
CustomLong1
|
Custom Long Field
|
|
x(255)
|
|
|
|
CustomNote
|
Custom Note Field
|
|
x(2000)
|
|
|
|
CustomShort0
|
Custom Short Field
|
|
x(20)
|
|
|
|
CustomShort1
|
Custom Short Field
|
|
x(20)
|
|
|
|
CustomShort2
|
Custom Short Field
|
|
x(20)
|
|
|
|
CustomShort3
|
Custom Short Field
|
|
x(20)
|
|
|
|
CustomShort4
|
Custom Short Field
|
|
x(20)
|
|
|
|
CustomShort5
|
Custom Short Field
|
|
x(20)
|
|
|
|
CustomShort6
|
Custom Short Field
|
|
x(20)
|
|
|
|
CustomShort7
|
Custom Short Field
|
|
x(20)
|
|
|
|
CustomShort8
|
Custom Short Field
|
|
x(20)
|
|
|
|
CustomShort9
|
Custom Short Field
|
|
x(20)
|
|
|
|
LastModifiedDate
|
Last Modified Date
|
Mod Date
|
99/99/9999
|
|
|
|
LastModifiedTime
|
Last Modified Time
|
Mod Time
|
99999
|
|
|
|
LastModifiedUser
|
Last Modified User
|
Mod User
|
x(20)
|
|
|
|
MatchingReason_ID
|
Status After Match
|
|
-99999999999
|
|
|
|
QADC01
|
|
|
x(40)
|
|
|
|
QADC02
|
|
|
x(255)
|
|
|
|
QADD01
|
|
|
->,>>>,>>9.9999
|
10
|
|
|
QADT01
|
|
|
99/99/9999
|
|
|
|
Reason_ID
|
Record ID
|
|
-99999999999
|
|
|
|
ReasonAllocationStatus
|
Allocation Status
|
|
x(20)
|
|
|
|
ReasonCode
|
Invoice Status Code
|
|
x(20)
|
|
|
|
ReasonDescription
|
Description
|
|
x(40)
|
|
|
|
ReasonIsActive
|
Active
|
|
yes/no
|
|
|
|
ReasonIsInitialStatus
|
Initial Status
|
|
yes/no
|
|
|
|
ReasonIsInvoiceApproved
|
Invoice Approved
|
Inv Approved
|
yes/no
|
|
|
|
ReasonIsLockPayment
|
Lock Payment
|
|
yes/no
|
|
|
|
ReasonIsLogisticMatching
|
Receiver Matching
|
|
yes/no
|
|
|
|
ReasonIsNoReminderCount
|
Do not Increment Reminder Count
|
|
yes/no
|
|
|
|
Index-Name
|
Uni
|
Field-Name
|
Asc
|
Abbr
|
|
|
Code
|
yes
|
ReasonCode
|
yes
|
no
|
|
|
IsInitialStatus
|
no
|
ReasonIsInitialStatus
|
yes
|
no
|
|
|
LastModIdx
|
no
|
LastModifiedDate
|
yes
|
no
|
|
|
MatchingReasonIdx
|
no
|
MatchingReason_ID
|
yes
|
no
|
|
∗
|
Prim
|
yes
|
Reason_ID
|
yes
|
no
|
|
|
ReasonAllocationStatus
|
no
|
ReasonAllocationStatus
|
yes
|
no
|
|
|
ReasonIsActive
|
no
|
ReasonIsActive
|
yes
|
no
|
|
|
ReasonIsInvApproved
|
no
|
ReasonIsInvoiceApproved
|
yes
|
no
|
|
|
ReasonIsLockPayment
|
no
|
ReasonIsLockPayment
|
yes
|
no
|
|
|
ViewIndex
|
no
|
ReasonIsActive
|
yes
|
no
|
|
|
|
|
ReasonCode
|
yes
|
no
|
|
|
Field Name
|
Label
|
Col-Label
|
Format
|
Dec
|
|
|
AfterApprovalReason_ID
|
Link to After Approval Reason
|
|
-99999999999
|
|
|
|
AfterDenialReason_ID
|
Link to After Denial Reason
|
|
-99999999999
|
|
|
|
BeforeApprovalReason_ID
|
Link to Before Approval Reason
|
|
-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
|
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
|
|
|
|
ReasonTrans_ID
|
Record ID
|
|
-99999999999
|
|
|
|
ReasonTransIsDefault
|
Default
|
|
yes/no
|
|
|
|
Index-Name
|
Uni
|
Field-Name
|
Asc
|
Abbr
|
|
∗
|
Prim
|
yes
|
ReasonTrans_ID
|
yes
|
no
|
|
|
UniqIdx
|
yes
|
BeforeApprovalReason_ID
|
yes
|
no
|
|
|
|
|
AfterApprovalReason_ID
|
yes
|
no
|
|
|
|
|
AfterDenialReason_ID
|
yes
|
no
|
|
|
Field Name
|
Label
|
Col-Label
|
Format
|
Dec
|
|
|
Addr
|
Address
|
|
x(8)
|
|
|
|
AltUM
|
Alt UM
|
Alt!UM
|
x(2)
|
|
|
|
CreateDate
|
Create Date
|
|
99/99/99
|
|
|
|
CreateUserID
|
Created
|
|
x(8)
|
|
|
|
Domain
|
Domain
|
|
x(8)
|
|
|
|
DSet
|
Data Set
|
|
x(12)
|
|
|
|
Line
|
Line/ID
|
|
x(8)
|
|
|
|
Loc
|
Location
|
|
x(8)
|
|
|
|
Lot
|
Lot/Serial
|
|
x(18)
|
|
|
|
ModDate
|
Modified Date
|
Mod Date
|
99/99/99
|
|
|
|
ModUserID
|
User ID
|
|
x(8)
|
|
|
|
Nbr
|
Order
|
|
x(18)
|
|
|
|
oid_ReceiptD
|
|
|
>>>>>>>>>>>>>>>>>>>>>>>>>>>9.9<<<<<<<<<
|
10
|
|
|
PackSlip
|
Packing Slip
|
|
x(12)
|
|
|
|
Part
|
Item Number
|
|
x(18)
|
|
|
|
QadC01
|
QAD Field
|
|
X(8)
|
0
|
|
|
QadC02
|
QAD Field
|
|
X(8)
|
0
|
|
|
QadC03
|
QAD Field
|
|
X(8)
|
0
|
|
|
QadC04
|
QAD Field
|
|
X(8)
|
0
|
|
|
QadD01
|
QAD Field
|
|
->>>>,>>>,>>9.99<<<
|
10
|
|
|
QadD02
|
QAD Field
|
|
->>>>,>>>,>>9.99<<<
|
10
|
|
|
QadD03
|
QAD Field
|
|
->>>>,>>>,>>9.99<<<
|
10
|
|
|
QadI01
|
QAD Field
|
|
->,>>>,>>9
|
|
|
|
QadI02
|
QAD Field
|
|
->,>>>,>>9
|
|
|
|
QadI03
|
QAD Field
|
|
->,>>>,>>9
|
|
|
|
QadL01
|
QAD Field
|
|
yes/no
|
|
|
|
QadL02
|
QAD Field
|
|
yes/no
|
|
|
|
QadT01
|
QAD Field
|
|
99/99/99
|
|
|
|
QadT02
|
QAD Field
|
|
99/99/99
|
|
|
|
QadT03
|
QAD Field
|
|
99/99/99
|
|
|
|
Quantity
|
Quantity
|
|
->,>>>,>>9.9<<<<<<<<
|
10
|
|
|
RecStatus
|
Status
|
St
|
x(12)
|
|
|
|
Ref
|
Reference
|
|
x(8)
|
|
|
|
Site
|
Site
|
|
x(8)
|
|
|
|
StartUserID
|
Start User
|
|
x(8)
|
|
|
|
User1
|
User 1
|
|
x(8)
|
|
|
|
User2
|
User 2
|
|
x(8)
|
|
|
|
UserC03
|
User Field Character 3
|
|
x(24)
|
|
|
|
UserC04
|
User Field Character 4
|
|
x(24)
|
|
|
|
UserC05
|
User Field Character 5
|
|
x(24)
|
|
|
|
UserD01
|
User Field Decimal 1
|
|
->>>>,>>>,>>9.9<<<<<<<<<
|
10
|
|
|
UserD02
|
User Field Decimal 2
|
|
->>>>,>>>,>>9.9<<<<<<<<<
|
10
|
|
|
UserL01
|
User Field Logical 1
|
|
yes/no
|
|
|
|
UserL02
|
User Field Logical 2
|
|
yes/no
|
|
|
|
UserT01
|
User Field Date 1
|
|
99/99/99
|
|
|
|
UserT02
|
User Field Date 2
|
|
99/99/99
|
|
|
|
Whse
|
Warehouse
|
Whse
|
x(8)
|
|
|
|
Index-Name
|
Uni
|
Field-Name
|
Asc
|
Abbr
|
|
∗
|
Line
|
yes
|
Domain
|
yes
|
no
|
|
|
|
|
Site
|
yes
|
no
|
|
|
|
|
Whse
|
yes
|
no
|
|
|
|
|
StartUserID
|
yes
|
no
|
|
|
|
|
Addr
|
yes
|
no
|
|
|
|
|
Loc
|
yes
|
no
|
|
|
|
|
Part
|
yes
|
no
|
|
|
|
|
Lot
|
yes
|
no
|
|
|
|
|
Ref
|
yes
|
no
|
|
|
|
|
DSet
|
yes
|
no
|
|
|
|
|
Nbr
|
yes
|
no
|
|
|
|
|
Line
|
yes
|
no
|
|
|
oid_ReceiptD
|
yes
|
oid_ReceiptD
|
yes
|
no
|
|
|
RecStatus
|
no
|
Domain
|
yes
|
no
|
|
|
|
|
Site
|
yes
|
no
|
|
|
|
|
Whse
|
yes
|
no
|
|
|
|
|
StartUserID
|
yes
|
no
|
|
|
|
|
RecStatus
|
yes
|
no
|
|
|
UsrIdx
|
no
|
Domain
|
yes
|
no
|
|
|
|
|
User1
|
yes
|
no
|
|
|
|
|
User2
|
yes
|
no
|
|
|
Field Name
|
Label
|
Col-Label
|
Format
|
Dec
|
|
|
Company_ID
|
Link to Company
|
|
-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)
|
|
|
|
Journal_ID
|
Daybook Code
|
|
-99999999999
|
|
|
|
LastModifiedDate
|
Last Modified Date
|
Mod Date
|
99/99/9999
|
|
|
|
LastModifiedTime
|
Last Modified Time
|
Mod Time
|
99999
|
|
|
|
LastModifiedUser
|
Last Modified User
|
Mod User
|
x(20)
|
|
|
|
PostingTemplate_ID
|
Template Code
|
|
-99999999999
|
|
|
|
QADC01
|
|
|
x(40)
|
|
|
|
QADC02
|
|
|
x(255)
|
|
|
|
QADD01
|
|
|
->,>>>,>>9.9999
|
10
|
|
|
QADT01
|
|
|
99/99/9999
|
|
|
|
RecEntry_ID
|
Record ID
|
|
-99999999999
|
|
|
|
RecEntryAmountLC
|
BC Amount
|
|
->>>,>>>,>>>,>>9.99
|
4
|
|
|
RecEntryCode
|
Code
|
|
x(20)
|
|
|
|
RecEntryEndDate
|
End Date
|
|
99/99/9999
|
|
|
|
RecEntryFreq
|
Frequency
|
|
x(20)
|
|
|
|
RecEntryIsActive
|
Active
|
|
yes/no
|
|
|
|
RecEntryIsAmountApply
|
Apply Amount
|
|
yes/no
|
|
|
|
RecEntryIsOpenEnded
|
Open End
|
|
yes/no
|
|
|
|
RecEntryIsReversing
|
Reverse in Next GL Period
|
Reverse
|
yes/no
|
|
|
|
RecEntryStartDate
|
Start Date
|
|
99/99/9999
|
|
|
|
RecEntryUpdate
|
Update Type
|
|
x(20)
|
|
|
|
Index-Name
|
Uni
|
Field-Name
|
Asc
|
Abbr
|
|
|
ActiveIdx
|
no
|
RecEntryIsActive
|
yes
|
no
|
|
|
Company
|
no
|
Company_ID
|
yes
|
no
|
|
|
Journal
|
no
|
Journal_ID
|
yes
|
no
|
|
|
PostingTemplate
|
no
|
PostingTemplate_ID
|
yes
|
no
|
|
∗
|
prim
|
yes
|
RecEntry_ID
|
yes
|
no
|
|
|
UniqueIdx
|
yes
|
Company_ID
|
yes
|
no
|
|
|
|
|
RecEntryCode
|
yes
|
no
|
|
|
ViewIndex
|
no
|
Company_ID
|
yes
|
no
|
|
|
|
|
RecEntryIsActive
|
yes
|
no
|
|
|
|
|
RecEntryCode
|
yes
|
no
|
|
|
Field Name
|
Label
|
Col-Label
|
Format
|
Dec
|
|
|
LastModifiedDate
|
Last Modified Date
|
Mod Date
|
99/99/9999
|
|
|
|
LastModifiedTime
|
Last Modified Time
|
Mod Time
|
99999
|
|
|
|
LastModifiedUser
|
Last Modified User
|
Mod User
|
x(20)
|
|
|
|
Period_ID
|
GL Period
|
GL Pd
|
-99999999999
|
|
|
|
QADC01
|
|
|
x(40)
|
|
|
|
QADC02
|
|
|
x(255)
|
|
|
|
QADD01
|
|
|
->,>>>,>>9.9999
|
10
|
|
|
QADT01
|
|
|
99/99/9999
|
|
|
|
RecEntry_ID
|
Link to RecEntry
|
|
-99999999999
|
|
|
|
RecEntryLine_ID
|
Record ID
|
|
-99999999999
|
|
|
|
RecEntryLineAmountLC
|
BC Amount
|
|
->>>,>>>,>>>,>>9.99
|
4
|
|
|
RecEntryLineCode
|
Code
|
|
x(20)
|
|
|
|
RecEntryLinePostingDate
|
Posting Date
|
|
99/99/9999
|
|
|
|
RecEntryLineReversingDate
|
Reversing Date
|
|
99/99/9999
|
|
|
|
RecEntryLineStatus
|
Status
|
|
x(20)
|
|
|
|
Index-Name
|
Uni
|
Field-Name
|
Asc
|
Abbr
|
|
|
CodeIdx
|
no
|
RecEntryLineCode
|
yes
|
no
|
|
|
PeriodIdx
|
no
|
Period_ID
|
yes
|
no
|
|
∗
|
prim
|
yes
|
RecEntryLine_ID
|
yes
|
no
|
|
|
RecEntryIdx
|
no
|
RecEntry_ID
|
yes
|
no
|
|
|
StatusIdx
|
no
|
RecEntryLineStatus
|
yes
|
no
|
|
|
Field Name
|
Label
|
Col-Label
|
Format
|
Dec
|
|
|
oid_reg_mstr
|
|
|
>>>>>>>>>>>>>>>>>>>>>>>>>>>9.9<<<<<<<<<
|
10
|
|
|
reg__chr01
|
|
|
x(8)
|
|
|
|
reg__chr02
|
|
|
x(8)
|
|
|
|
reg__chr03
|
|
|
x(8)
|
|
|
|
reg__dec01
|
|
|
->>>,>>>,>>9.99
|
10
|
|
|
reg__dec02
|
|
|
->>>,>>>,>>9.99
|
10
|
|
|
reg__dte01
|
|
|
99/99/99
|
|
|
|
reg__dte02
|
|
|
99/99/99
|
|
|
|
reg__log01
|
|
|
yes/no
|
|
|
|
reg__log02
|
|
|
yes/no
|
|
|
|
reg__qadc01
|
QAD Character Field 1
|
|
X(8)
|
|
|
|
reg__qadc02
|
QAD Character Field 2
|
|
X(8)
|
|
|
|
reg__qadc03
|
QAD Character Field 3
|
|
X(8)
|
|
|
|
reg__qadc04
|
|
|
x(8)
|
|
|
|
reg__qadc05
|
|
|
x(4)
|
|
|
|
reg__qade01
|
QAD Decimal Field 1
|
|
->>>,>>>,>>9.99<<
|
10
|
|
|
reg__qadl01
|
QAD Logical Field 1
|
|
yes/no
|
|
|
|
reg__qadl02
|
QAD Logical Field 2
|
|
yes/no
|
|
|
|
reg__qadt01
|
QAD Date Field 1
|
|
99/99/99
|
|
|
|
reg_3rd_party
|
Third Party
|
|
yes/no
|
|
|
|
reg_code
|
Area
|
|
x(18)
|
|
|
|
reg_desc
|
Description
|
|
x(24)
|
|
|
|
reg_domain
|
Domain
|
|
x(8)
|
|
|
|
reg_lang
|
Language
|
|
x(2)
|
|
|
|
reg_loc
|
Location
|
|
x(8)
|
|
|
|
reg_loc_rtn
|
Defective Location
|
Df Loc
|
x(8)
|
|
|
|
reg_mod_date
|
Modified Date
|
Mod Date
|
99/99/99
|
|
|
|
reg_mod_userid
|
User ID
|
|
X(8)
|
|
|
|
reg_prod_line
|
Product Line
|
Prod
|
x(8)
|
|
|
|
reg_project
|
Project
|
|
x(8)
|
|
|
|
reg_repair
|
Repair Center
|
|
yes/no
|
|
|
|
reg_site
|
Site
|
|
x(8)
|
|
|
|
reg_site_rtn
|
Defective Site
|
Df Site
|
x(8)
|
|
|
|
reg_time_zone
|
Hours from GMT
|
|
>>9
|
|
|
|
reg_type
|
Type
|
|
x(8)
|
|
|
|
reg_user1
|
Ufld1
|
|
x(8)
|
|
|
|
reg_user2
|
Ufld2
|
|
x(8)
|
|
|
|
reg_wkctr
|
Work Center
|
Work Ctr
|
x(8)
|
|
|
|
Index-Name
|
Uni
|
Field-Name
|
Asc
|
Abbr
|
|
|
oid_reg_mstr
|
yes
|
oid_reg_mstr
|
yes
|
no
|
|
∗
|
reg_code
|
yes
|
reg_domain
|
yes
|
no
|
|
|
|
|
reg_code
|
yes
|
no
|
|
|
Field Name
|
Label
|
Col-Label
|
Format
|
Dec
|
|
|
CreateDate
|
Create Date
|
|
99/99/99
|
|
|
|
CreateUserID
|
Created
|
|
x(8)
|
|
|
|
Domain
|
Domain
|
|
x(8)
|
|
|
|
InvStatus
|
Status
|
|
X(8)
|
|
|
|
ModDate
|
Modified
|
|
99/99/99
|
|
|
|
ModUserID
|
Modified
|
|
x(8)
|
|
|
|
oid_RelStatM
|
|
|
>>>>>>>>>>>>>>>>>>>>>>>>>>>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
|
|
|
|
RelStatus
|
Release/Inspect Status
|
Rel/Insp St
|
x(8)
|
|
|
|
User1
|
User 1
|
|
x(8)
|
|
|
|
User2
|
User 2
|
|
x(8)
|
|
|
|
UserC03
|
User Field Character 3
|
|
x(24)
|
|
|
|
UserC04
|
User Field Character 4
|
|
x(24)
|
|
|
|
UserC05
|
User Field Character 5
|
|
x(24)
|
|
|
|
UserD01
|
User Field Decimal 1
|
|
->>>>,>>>,>>9.9<<<<<<<<<
|
10
|
|
|
UserD02
|
User Field Decimal 2
|
|
->>>>,>>>,>>9.9<<<<<<<<<
|
10
|
|
|
UserL01
|
User Field Logical 1
|
|
yes/no
|
|
|
|
UserL02
|
User Field Logical 2
|
|
yes/no
|
|
|
|
UserT01
|
User Field Date 1
|
|
99/99/99
|
|
|
|
UserT02
|
User Field Date 2
|
|
99/99/99
|
|
|
|
Index-Name
|
Uni
|
Field-Name
|
Asc
|
Abbr
|
|
∗
|
InvStatus
|
yes
|
Domain
|
yes
|
no
|
|
|
|
|
InvStatus
|
yes
|
no
|
|
|
oid_RelStatM
|
yes
|
oid_RelStatM
|
yes
|
no
|
|
|
RelStatus
|
no
|
Domain
|
yes
|
no
|
|
|
|
|
RelStatus
|
yes
|
no
|
|
|
UsrIdx
|
no
|
Domain
|
yes
|
no
|
|
|
|
|
User1
|
yes
|
no
|
|
|
|
|
User2
|
yes
|
no
|
|
|
Field Name
|
Label
|
Col-Label
|
Format
|
Dec
|
|
|
CreateDate
|
Create Date
|
|
99/99/99
|
|
|
|
CreateUserID
|
Created
|
|
x(8)
|
|
|
|
Domain
|
Domain
|
|
x(8)
|
|
|
|
MinQtyRule
|
Minimum Quantity Rule
|
Min!Qty!Rule
|
yes/no
|
|
|
|
ModDate
|
Modified
|
|
99/99/99
|
|
|
|
ModUserID
|
Modified
|
|
x(8)
|
|
|
|
oid_ReplenC
|
|
|
>>>>>>>>>>>>>>>>>>>>>>>>>>>9.9<<<<<<<<<
|
10
|
|
|
QadC01
|
QAD Field
|
|
X(8)
|
0
|
|
|
QadC02
|
QAD Field
|
|
X(8)
|
0
|
|
|
QadC03
|
QAD Field
|
|
X(8)
|
0
|
|
|
QadC04
|
QAD Field
|
|
X(8)
|
0
|
|
|
QadD01
|
QAD Field
|
|
->>>>,>>>,>>9.99<<<
|
10
|
|
|
QadD02
|
QAD Field
|
|
->>>>,>>>,>>9.99<<<
|
10
|
|
|
QadD03
|
QAD Field
|
|
->>>>,>>>,>>9.99<<<
|
10
|
|
|
QadI01
|
QAD Field
|
|
->,>>>,>>9
|
|
|
|
QadI02
|
QAD Field
|
|
->,>>>,>>9
|
|
|
|
QadI03
|
QAD Field
|
|
->,>>>,>>9
|
|
|
|
QadL01
|
QAD Field
|
|
yes/no
|
|
|
|
QadL02
|
QAD Field
|
|
yes/no
|
|
|
|
QadT01
|
QAD Field
|
|
99/99/99
|
|
|
|
QadT02
|
QAD Field
|
|
99/99/99
|
|
|
|
QadT03
|
QAD Field
|
|
99/99/99
|
|
|
|
UniqueID
|
|
|
9
|
|
|
|
User1
|
User 1
|
|
x(8)
|
|
|
|
User2
|
User 2
|
|
x(8)
|
|
|
|
UserC03
|
User Field Character 3
|
|
x(24)
|
|
|
|
UserC04
|
User Field Character 4
|
|
x(24)
|
|
|
|
UserC05
|
User Field Character 5
|
|
x(24)
|
|
|
|
UserD01
|
User Field Decimal 1
|
|
->>>>,>>>,>>9.9<<<<<<<<<
|
10
|
|
|
UserD02
|
User Field Decimal 2
|
|
->>>>,>>>,>>9.9<<<<<<<<<
|
10
|
|
|
UserL01
|
User Field Logical 1
|
|
yes/no
|
|
|
|
UserL02
|
User Field Logical 2
|
|
yes/no
|
|
|
|
UserT01
|
User Field Date 1
|
|
99/99/99
|
|
|
|
UserT02
|
User Field Date 2
|
|
99/99/99
|
|
|
|
Index-Name
|
Uni
|
Field-Name
|
Asc
|
Abbr
|
|
|
oid_ReplenC
|
yes
|
oid_ReplenC
|
yes
|
no
|
|
∗
|
UniqueID
|
yes
|
Domain
|
yes
|
no
|
|
|
|
|
UniqueID
|
yes
|
no
|
|
|
UsrIdx
|
no
|
Domain
|
yes
|
no
|
|
|
|
|
User1
|
yes
|
no
|
|
|
|
|
User2
|
yes
|
no
|
|
|
Field Name
|
Label
|
Col-Label
|
Format
|
Dec
|
|
|
CreateDate
|
Create Date
|
|
99/99/99
|
|
|
|
CreateUserID
|
Created
|
|
x(8)
|
|
|
|
Domain
|
Domain
|
|
x(8)
|
|
|
|
ModDate
|
Modified Date
|
Mod Date
|
99/99/99
|
|
|
|
ModUserID
|
User ID
|
|
x(8)
|
|
|
|
oid_RepListD
|
|
|
>>>>>>>>>>>>>>>>>>>>>>>>>>>9.9<<<<<<<<<
|
10
|
|
|
QadC01
|
QAD Field
|
|
X(8)
|
0
|
|
|
QadC02
|
QAD Field
|
|
X(8)
|
0
|
|
|
QadC03
|
QAD Field
|
|
X(8)
|
0
|
|
|
QadC04
|
QAD Field
|
|
X(8)
|
0
|
|
|
QadD01
|
QAD Field
|
|
->>>>,>>>,>>9.99<<<
|
10
|
|
|
QadD02
|
QAD Field
|
|
->>>>,>>>,>>9.99<<<
|
10
|
|
|
QadD03
|
QAD Field
|
|
->>>>,>>>,>>9.99<<<
|
10
|
|
|
QadI01
|
QAD Field
|
|
->,>>>,>>9
|
|
|
|
QadI02
|
QAD Field
|
|
->,>>>,>>9
|
|
|
|
QadI03
|
QAD Field
|
|
->,>>>,>>9
|
|
|
|
QadL01
|
QAD Field
|
|
yes/no
|
|
|
|
QadL02
|
QAD Field
|
|
yes/no
|
|
|
|
QadT01
|
QAD Field
|
|
99/99/99
|
|
|
|
QadT02
|
QAD Field
|
|
99/99/99
|
|
|
|
QadT03
|
QAD Field
|
|
99/99/99
|
|
|
|
RepList
|
Replenishment List
|
Rep List
|
x(8)
|
|
|
|
RepSeq
|
Seq
|
|
>>9
|
|
|
|
Site
|
Site
|
|
x(8)
|
|
|
|
SLocGp
|
Store Loc Group
|
SLocGrp
|
x(8)
|
|
|
|
User1
|
User 1
|
|
x(8)
|
|
|
|
User2
|
User 2
|
|
x(8)
|
|
|
|
UserC03
|
User Field Character 3
|
|
x(24)
|
|
|
|
UserC04
|
User Field Character 4
|
|
x(24)
|
|
|
|
UserC05
|
User Field Character 5
|
|
x(24)
|
|
|
|
UserD01
|
User Field Decimal 1
|
|
->>>>,>>>,>>9.9<<<<<<<<<
|
10
|
|
|
UserD02
|
User Field Decimal 2
|
|
->>>>,>>>,>>9.9<<<<<<<<<
|
10
|
|
|
UserL01
|
User Field Logical 1
|
|
yes/no
|
|
|
|
UserL02
|
User Field Logical 2
|
|
yes/no
|
|
|
|
UserT01
|
User Field Date 1
|
|
99/99/99
|
|
|
|
UserT02
|
User Field Date 2
|
|
99/99/99
|
|
|
|
Whse
|
Warehouse
|
Whse
|
x(8)
|
|
|
|
Index-Name
|
Uni
|
Field-Name
|
Asc
|
Abbr
|
|
∗
|
ListSeq
|
yes
|
Domain
|
yes
|
no
|
|
|
|
|
Site
|
yes
|
no
|
|
|
|
|
RepList
|
yes
|
no
|
|
|
|
|
RepSeq
|
yes
|
no
|
|
|
ListSLG
|
yes
|
Domain
|
yes
|
no
|
|
|
|
|
Site
|
yes
|
no
|
|
|
|
|
RepList
|
yes
|
no
|
|
|
|
|
Whse
|
yes
|
no
|
|
|
|
|
SLocGp
|
yes
|
no
|
|
|
oid_RepListD
|
yes
|
oid_RepListD
|
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)
|
|
|
|
ModDate
|
Modified
|
|
99/99/99
|
|
|
|
ModUserID
|
Modified
|
|
x(8)
|
|
|
|
oid_RepListM
|
|
|
>>>>>>>>>>>>>>>>>>>>>>>>>>>9.9<<<<<<<<<
|
10
|
|
|
QadC01
|
QAD Field
|
|
X(8)
|
0
|
|
|
QadC02
|
QAD Field
|
|
X(8)
|
0
|
|
|
QadC03
|
QAD Field
|
|
X(8)
|
0
|
|
|
QadC04
|
QAD Field
|
|
X(8)
|
0
|
|
|
QadD01
|
QAD Field
|
|
->>>>,>>>,>>9.99<<<
|
10
|
|
|
QadD02
|
QAD Field
|
|
->>>>,>>>,>>9.99<<<
|
10
|
|
|
QadD03
|
QAD Field
|
|
->>>>,>>>,>>9.99<<<
|
10
|
|
|
QadI01
|
QAD Field
|
|
->,>>>,>>9
|
|
|
|
QadI02
|
QAD Field
|
|
->,>>>,>>9
|
|
|
|
QadI03
|
QAD Field
|
|
->,>>>,>>9
|
|
|
|
QadL01
|
QAD Field
|
|
yes/no
|
|
|
|
QadL02
|
QAD Field
|
|
yes/no
|
|
|
|
QadT01
|
QAD Field
|
|
99/99/99
|
|
|
|
QadT02
|
QAD Field
|
|
99/99/99
|
|
|
|
QadT03
|
QAD Field
|
|
99/99/99
|
|
|
|
RepList
|
Replenishment List
|
Rep List
|
X(8)
|
|
|
|
Site
|
Site
|
|
x(8)
|
|
|
|
User1
|
User 1
|
|
x(8)
|
|
|
|
User2
|
User 2
|
|
x(8)
|
|
|
|
UserC03
|
User Field Character 3
|
|
x(24)
|
|
|
|
UserC04
|
User Field Character 4
|
|
x(24)
|
|
|
|
UserC05
|
User Field Character 5
|
|
x(24)
|
|
|
|
UserD01
|
User Field Decimal 1
|
|
->>>>,>>>,>>9.9<<<<<<<<<
|
10
|
|
|
UserD02
|
User Field Decimal 2
|
|
->>>>,>>>,>>9.9<<<<<<<<<
|
10
|
|
|
UserL01
|
User Field Logical 1
|
|
yes/no
|
|
|
|
UserL02
|
User Field Logical 2
|
|
yes/no
|
|
|
|
UserT01
|
User Field Date 1
|
|
99/99/99
|
|
|
|
UserT02
|
User Field Date 2
|
|
99/99/99
|
|
|
|
Index-Name
|
Uni
|
Field-Name
|
Asc
|
Abbr
|
|
|
oid_RepListM
|
yes
|
oid_RepListM
|
yes
|
no
|
|
∗
|
SiteList
|
yes
|
Domain
|
yes
|
no
|
|
|
|
|
Site
|
yes
|
no
|
|
|
|
|
RepList
|
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)
|
|
|
|
Domain
|
Domain
|
|
x(8)
|
|
|
|
EndDate
|
End Date
|
|
99/99/99
|
|
|
|
Loc
|
Location
|
|
x(8)
|
|
|
|
MaxQty
|
Maximum Quantity
|
Maximum!Quantity
|
->,>>>,>>9.9<<<<<<<<
|
10
|
|
|
MinPct
|
Minimum %
|
Min %
|
->>9.99
|
2
|
|
|
ModDate
|
Modified
|
|
99/99/99
|
|
|
|
ModUserID
|
Modified
|
|
x(8)
|
|
|
|
oid_RepLocM
|
|
|
>>>>>>>>>>>>>>>>>>>>>>>>>>>9.9<<<<<<<<<
|
10
|
|
|
Part
|
Item Number
|
|
x(18)
|
|
|
|
QadC01
|
QAD Field
|
|
X(8)
|
0
|
|
|
QadC02
|
QAD Field
|
|
X(8)
|
0
|
|
|
QadC03
|
QAD Field
|
|
X(8)
|
0
|
|
|
QadC04
|
QAD Field
|
|
X(8)
|
0
|
|
|
QadD01
|
QAD Field
|
|
->>>>,>>>,>>9.99<<<
|
10
|
|
|
QadD02
|
QAD Field
|
|
->>>>,>>>,>>9.99<<<
|
10
|
|
|
QadD03
|
QAD Field
|
|
->>>>,>>>,>>9.99<<<
|
10
|
|
|
QadI01
|
QAD Field
|
|
->,>>>,>>9
|
|
|
|
QadI02
|
QAD Field
|
|
->,>>>,>>9
|
|
|
|
QadI03
|
QAD Field
|
|
->,>>>,>>9
|
|
|
|
QadL01
|
QAD Field
|
|
yes/no
|
|
|
|
QadL02
|
QAD Field
|
|
yes/no
|
|
|
|
QadT01
|
QAD Field
|
|
99/99/99
|
|
|
|
QadT02
|
QAD Field
|
|
99/99/99
|
|
|
|
QadT03
|
QAD Field
|
|
99/99/99
|
|
|
|
RepList
|
Replenishment List
|
Rep List
|
X(8)
|
|
|
|
RepQty
|
Replenishment Point
|
Rep Point
|
->,>>>,>>9.9<<<<<<<<
|
10
|
|
|
RepType
|
Replenishment Type
|
Rep Type
|
X(8)
|
|
|
|
RepUM
|
Rep UM
|
Rep!UM
|
X(2)
|
|
|
|
Site
|
Site
|
|
x(8)
|
|
|
|
StartDate
|
Start Date
|
|
99/99/99
|
|
|
|
User1
|
User 1
|
|
x(8)
|
|
|
|
User2
|
User 2
|
|
x(8)
|
|
|
|
UserC03
|
User Field Character 3
|
|
x(24)
|
|
|
|
UserC04
|
User Field Character 4
|
|
x(24)
|
|
|
|
UserC05
|
User Field Character 5
|
|
x(24)
|
|
|
|
UserD01
|
User Field Decimal 1
|
|
->>>>,>>>,>>9.9<<<<<<<<<
|
10
|
|
|
UserD02
|
User Field Decimal 2
|
|
->>>>,>>>,>>9.9<<<<<<<<<
|
10
|
|
|
UserL01
|
User Field Logical 1
|
|
yes/no
|
|
|
|
UserL02
|
User Field Logical 2
|
|
yes/no
|
|
|
|
UserT01
|
User Field Date 1
|
|
99/99/99
|
|
|
|
UserT02
|
User Field Date 2
|
|
99/99/99
|
|
|
|
Index-Name
|
Uni
|
Field-Name
|
Asc
|
Abbr
|
|
∗
|
LocPart
|
yes
|
Domain
|
yes
|
no
|
|
|
|
|
Site
|
yes
|
no
|
|
|
|
|
Loc
|
yes
|
no
|
|
|
|
|
Part
|
yes
|
no
|
|
|
|
|
RepType
|
yes
|
no
|
|
|
|
|
StartDate
|
yes
|
no
|
|
|
oid_RepLocM
|
yes
|
oid_RepLocM
|
yes
|
no
|
|
|
PartLoc
|
yes
|
Domain
|
yes
|
no
|
|
|
|
|
Part
|
yes
|
no
|
|
|
|
|
RepType
|
yes
|
no
|
|
|
|
|
Site
|
yes
|
no
|
|
|
|
|
Loc
|
yes
|
no
|
|
|
|
|
StartDate
|
yes
|
no
|
|
|
UsrIdx
|
no
|
Domain
|
yes
|
no
|
|
|
|
|
User1
|
yes
|
no
|
|
|
|
|
User2
|
yes
|
no
|
|
|
Field Name
|
Label
|
Col-Label
|
Format
|
Dec
|
|
|
CustomCombo0
|
Custom Combo Field
|
|
x(20)
|
|
|
|
CustomCombo1
|
Custom Combo Field
|
|
x(20)
|
|
|
|
CustomCombo2
|
Custom Combo Field
|
|
x(20)
|
|
|
|
CustomCombo3
|
Custom Combo Field
|
|
x(20)
|
|
|
|
CustomCombo4
|
Custom Combo Field
|
|
x(20)
|
|
|
|
CustomCombo5
|
Custom Combo Field
|
|
x(20)
|
|
|
|
CustomCombo6
|
Custom Combo Field
|
|
x(20)
|
|
|
|
CustomCombo7
|
Custom Combo Field
|
|
x(20)
|
|
|
|
CustomCombo8
|
Custom Combo Field
|
|
x(20)
|
|
|
|
CustomCombo9
|
Custom Combo Field
|
|
x(20)
|
|
|
|
CustomDate0
|
Custom Date Field
|
|
99/99/9999
|
|
|
|
CustomDate1
|
Custom Date Field
|
|
99/99/9999
|
|
|
|
CustomDate2
|
Custom Date Field
|
|
99/99/9999
|
|
|
|
CustomDate3
|
Custom Date Field
|
|
99/99/9999
|
|
|
|
CustomDate4
|
Custom Date Field
|
|
99/99/9999
|
|
|
|
CustomDecimal0
|
Custom Decimal Field
|
|
->,>>>,>>9.99
|
4
|
|
|
CustomDecimal1
|
Custom Decimal Field
|
|
->,>>>,>>9.99
|
4
|
|
|
CustomDecimal2
|
Custom Decimal Field
|
|
->,>>>,>>9.99
|
4
|
|
|
CustomDecimal3
|
Custom Decimal Field
|
|
->,>>>,>>9.99
|
4
|
|
|
CustomDecimal4
|
Custom Decimal Field
|
|
->,>>>,>>9.99
|
4
|
|
|
CustomInteger0
|
Custom Integer Field
|
|
->,>>>,>>9
|
|
|
|
CustomInteger1
|
Custom Integer Field
|
|
->,>>>,>>9
|
|
|
|
CustomInteger2
|
Custom Integer Field
|
|
->,>>>,>>9
|
|
|
|
CustomInteger3
|
Custom Integer Field
|
|
->,>>>,>>9
|
|
|
|
CustomInteger4
|
Custom Integer Field
|
|
->,>>>,>>9
|
|
|
|
CustomLong0
|
Custom Long Field
|
|
x(255)
|
|
|
|
CustomLong1
|
Custom Long Field
|
|
x(255)
|
|
|
|
CustomNote
|
Custom Note Field
|
|
x(2000)
|
|
|
|
CustomShort0
|
Custom Short Field
|
|
x(20)
|
|
|
|
CustomShort1
|
Custom Short Field
|
|
x(20)
|
|
|
|
CustomShort2
|
Custom Short Field
|
|
x(20)
|
|
|
|
CustomShort3
|
Custom Short Field
|
|
x(20)
|
|
|
|
CustomShort4
|
Custom Short Field
|
|
x(20)
|
|
|
|
CustomShort5
|
Custom Short Field
|
|
x(20)
|
|
|
|
CustomShort6
|
Custom Short Field
|
|
x(20)
|
|
|
|
CustomShort7
|
Custom Short Field
|
|
x(20)
|
|
|
|
CustomShort8
|
Custom Short Field
|
|
x(20)
|
|
|
|
CustomShort9
|
Custom Short Field
|
|
x(20)
|
|
|
|
LastModifiedDate
|
Last Modified Date
|
Mod Date
|
99/99/9999
|
|
|
|
LastModifiedTime
|
Last Modified Time
|
Mod Time
|
99999
|
|
|
|
LastModifiedUser
|
Last Modified User
|
Mod User
|
x(20)
|
|
|
|
QADC01
|
|
|
x(40)
|
|
|
|
QADC02
|
|
|
x(255)
|
|
|
|
QADD01
|
|
|
->,>>>,>>9.9999
|
10
|
|
|
QADT01
|
|
|
99/99/9999
|
|
|
|
ReportPeriod_ID
|
Record ID
|
|
-99999999999
|
|
|
|
ReportPeriodEndDate
|
End Date
|
|
99/99/9999
|
|
|
|
ReportPeriodIsReported
|
Reported
|
|
yes/no
|
|
|
|
ReportPeriodPeriod
|
GL Period
|
|
99
|
|
|
|
ReportPeriodStartDate
|
Start Date
|
|
99/99/9999
|
|
|
|
ReportPeriodYear
|
Year
|
|
9999
|
|
|
|
Index-Name
|
Uni
|
Field-Name
|
Asc
|
Abbr
|
|
|
EndDateIdx
|
no
|
ReportPeriodEndDate
|
yes
|
no
|
|
|
IsReportedIdx
|
no
|
ReportPeriodIsReported
|
yes
|
no
|
|
∗
|
Prim
|
yes
|
ReportPeriod_ID
|
yes
|
no
|
|
|
ReportPeriodIdx
|
no
|
ReportPeriodPeriod
|
yes
|
no
|
|
|
ReportYearIdx
|
no
|
ReportPeriodYear
|
yes
|
no
|
|
|
StartDateIdx
|
no
|
ReportPeriodStartDate
|
yes
|
no
|
|
|
UniqueIdx
|
yes
|
ReportPeriodYear
|
yes
|
no
|
|
|
|
|
ReportPeriodPeriod
|
yes
|
no
|
|
|
Field Name
|
Label
|
Col-Label
|
Format
|
Dec
|
|
|
CmtIndx
|
Comments
|
|
>>>>>>>9
|
|
|
|
CreateDate
|
Create Date
|
|
99/99/99
|
|
|
|
CreateUserID
|
Created
|
|
x(8)
|
|
|
|
Domain
|
Domain
|
|
x(8)
|
|
|
|
EndDate
|
End Date
|
|
99/99/99
|
|
|
|
MaxQty
|
Maximum Quantity
|
Maximum!Quantity
|
->,>>>,>>9.9<<<<<<<<
|
10
|
|
|
ModDate
|
Modified
|
|
99/99/99
|
|
|
|
ModUserID
|
Modified
|
|
x(8)
|
|
|
|
oid_RepSLGM
|
|
|
>>>>>>>>>>>>>>>>>>>>>>>>>>>9.9<<<<<<<<<
|
10
|
|
|
Part
|
Item Number
|
|
x(18)
|
|
|
|
QadC01
|
QAD Field
|
|
X(8)
|
0
|
|
|
QadC02
|
QAD Field
|
|
X(8)
|
0
|
|
|
QadC03
|
QAD Field
|
|
X(8)
|
0
|
|
|
QadC04
|
QAD Field
|
|
X(8)
|
0
|
|
|
QadD01
|
QAD Field
|
|
->>>>,>>>,>>9.99<<<
|
10
|
|
|
QadD02
|
QAD Field
|
|
->>>>,>>>,>>9.99<<<
|
10
|
|
|
QadD03
|
QAD Field
|
|
->>>>,>>>,>>9.99<<<
|
10
|
|
|
QadI01
|
QAD Field
|
|
->,>>>,>>9
|
|
|
|
QadI02
|
QAD Field
|
|
->,>>>,>>9
|
|
|
|
QadI03
|
QAD Field
|
|
->,>>>,>>9
|
|
|
|
QadL01
|
QAD Field
|
|
yes/no
|
|
|
|
QadL02
|
QAD Field
|
|
yes/no
|
|
|
|
QadT01
|
QAD Field
|
|
99/99/99
|
|
|
|
QadT02
|
QAD Field
|
|
99/99/99
|
|
|
|
QadT03
|
QAD Field
|
|
99/99/99
|
|
|
|
RepList
|
Replenishment List
|
Rep List
|
X(8)
|
|
|
|
RepQty
|
Replenishment Point
|
Rep Point
|
->,>>>,>>9.9<<<<<<<<
|
10
|
|
|
RepType
|
Replenishment Type
|
Rep Type
|
X(8)
|
|
|
|
RepUM
|
RepUM
|
Rep!UM
|
X(2)
|
|
|
|
Site
|
Site
|
|
x(8)
|
|
|
|
SLocGp
|
Store Loc Group
|
SLocGrp
|
x(8)
|
|
|
|
StartDate
|
Start Date
|
|
99/99/99
|
|
|
|
User1
|
User 1
|
|
x(8)
|
|
|
|
User2
|
User 2
|
|
x(8)
|
|
|
|
UserC03
|
User Field Character 3
|
|
x(24)
|
|
|
|
UserC04
|
User Field Character 4
|
|
x(24)
|
|
|
|
UserC05
|
User Field Character 5
|
|
x(24)
|
|
|
|
UserD01
|
User Field Decimal 1
|
|
->>>>,>>>,>>9.9<<<<<<<<<
|
10
|
|
|
UserD02
|
User Field Decimal 2
|
|
->>>>,>>>,>>9.9<<<<<<<<<
|
10
|
|
|
UserL01
|
User Field Logical 1
|
|
yes/no
|
|
|
|
UserL02
|
User Field Logical 2
|
|
yes/no
|
|
|
|
UserT01
|
User Field Date 1
|
|
99/99/99
|
|
|
|
UserT02
|
User Field Date 2
|
|
99/99/99
|
|
|
|
Whse
|
Warehouse
|
Whse
|
x(8)
|
|
|
|
Index-Name
|
Uni
|
Field-Name
|
Asc
|
Abbr
|
|
|
oid_RepSLGM
|
yes
|
oid_RepSLGM
|
yes
|
no
|
|
|
Part
|
yes
|
Domain
|
yes
|
no
|
|
|
|
|
Part
|
yes
|
no
|
|
|
|
|
RepType
|
yes
|
no
|
|
|
|
|
Site
|
yes
|
no
|
|
|
|
|
Whse
|
yes
|
no
|
|
|
|
|
SLocGp
|
yes
|
no
|
|
|
|
|
StartDate
|
yes
|
no
|
|
∗
|
SLG
|
yes
|
Domain
|
yes
|
no
|
|
|
|
|
Site
|
yes
|
no
|
|
|
|
|
Whse
|
yes
|
no
|
|
|
|
|
SLocGp
|
yes
|
no
|
|
|
|
|
RepType
|
yes
|
no
|
|
|
|
|
Part
|
yes
|
no
|
|
|
|
|
StartDate
|
yes
|
no
|
|
|
UsrIdx
|
no
|
Domain
|
yes
|
no
|
|
|
|
|
User1
|
yes
|
no
|
|
|
|
|
User2
|
yes
|
no
|
|
|
Field Name
|
Label
|
Col-Label
|
Format
|
Dec
|
|
|
oid_req_det
|
|
|
>>>>>>>>>>>>>>>>>>>>>>>>>>>9.9<<<<<<<<<
|
10
|
|
|
req__chr01
|
|
|
x(8)
|
|
|
|
req__chr02
|
|
|
x(8)
|
|
|
|
req__chr03
|
|
|
x(8)
|
|
|
|
req__chr04
|
|
|
x(8)
|
|
|
|
req__chr05
|
|
|
x(8)
|
|
|
|
req__dec01
|
|
|
>>>,>>>,>>9.99
|
10
|
|
|
req__dec02
|
|
|
>>>,>>>,>>9.99
|
10
|
|
|
req__dte01
|
|
|
99/99/99
|
|
|
|
req__dte02
|
|
|
99/99/99
|
|
|
|
req__log01
|
|
|
yes/no
|
|
|
|
req_acct
|
Pur Acct
|
|
x(8)
|
|
|
|
req_app_owner
|
Owner Application
|
|
x(12)
|
|
|
|
req_approved
|
Approved
|
Apr
|
yes/no
|
|
|
|
req_apr_by
|
Approved By
|
Aprv By
|
x(8)
|
|
|
|
req_apr_code
|
Approval Code
|
Apr Code
|
x(8)
|
|
|
|
req_apr_ent
|
Approved Entered By
|
Aprv Ent
|
x(8)
|
|
|
|
req_apr_prnt
|
Print Approval
|
Print Apr
|
yes/no
|
|
|
|
req_cc
|
Cost Ctr
|
CC
|
x(4)
|
|
|
|
req_cmtindx
|
Comment Index
|
Comment
|
>>>>>>>9
|
|
|
|
req_daybookset
|
Daybook Set
|
Dybk Set
|
x(8)
|
|
|
|
req_domain
|
Domain
|
|
x(8)
|
|
|
|
req_line
|
Line
|
|
>>>
|
|
|
|
req_nbr
|
Requisition
|
Req
|
x(8)
|
|
|
|
req_need
|
Need Date
|
Need
|
99/99/99
|
|
|
|
req_part
|
Item Number
|
|
x(18)
|
|
|
|
req_po_site
|
PO Site
|
|
x(8)
|
|
|
|
req_print
|
Print Requisition
|
Print
|
yes/no
|
|
|
|
req_project
|
Project
|
|
x(8)
|
|
|
|
req_pur_cost
|
Unit Cost
|
|
->,>>>,>>>,>>9.99<<<
|
10
|
|
|
req_qty
|
Qty
|
|
->,>>>,>>9.9<<<<<<<<
|
10
|
|
|
req_rel_date
|
Release Date
|
Release
|
99/99/99
|
|
|
|
req_request
|
Requested By
|
Req By
|
x(8)
|
|
|
|
req_site
|
Site
|
|
x(8)
|
|
|
|
req_so_job
|
Sales/Job
|
|
x(8)
|
|
|
|
req_sub
|
Pur Sub-Acct
|
Sub-Acct
|
x(8)
|
|
|
|
req_um
|
UM
|
|
x(2)
|
|
|
|
req_user1
|
Ufld1
|
|
x(8)
|
|
|
|
req_user2
|
Ufld2
|
|
x(8)
|
|
|
|
Index-Name
|
Uni
|
Field-Name
|
Asc
|
Abbr
|
|
|
oid_req_det
|
yes
|
oid_req_det
|
yes
|
no
|
|
|
req_apr_code
|
yes
|
req_domain
|
yes
|
no
|
|
|
|
|
req_apr_code
|
yes
|
no
|
|
|
|
|
req_nbr
|
yes
|
no
|
|
|
|
|
req_line
|
yes
|
no
|
|
∗
|
req_nbr
|
yes
|
req_domain
|
yes
|
no
|
|
|
|
|
req_nbr
|
yes
|
no
|
|
|
|
|
req_line
|
yes
|
no
|
|
|
req_part
|
no
|
req_domain
|
yes
|
no
|
|
|
|
|
req_part
|
yes
|
no
|
|
|
Field Name
|
Label
|
Col-Label
|
Format
|
Dec
|
|
|
BusActivity_ID
|
Business Activity
|
|
-99999999999
|
|
|
|
LastModifiedDate
|
Last Modified Date
|
Mod Date
|
99/99/9999
|
|
|
|
LastModifiedTime
|
Last Modified Time
|
Mod Time
|
99999
|
|
|
|
LastModifiedUser
|
Last Modified User
|
Mod User
|
x(20)
|
|
|
|
ObsoleteResourceCategory
|
Resource Category
|
|
x(8)
|
|
|
|
QADC01
|
|
|
x(40)
|
|
|
|
QADC02
|
|
|
x(255)
|
|
|
|
QADD01
|
|
|
->,>>>,>>9.9999
|
10
|
|
|
QADT01
|
|
|
99/99/9999
|
|
|
|
Resource_ID
|
Record ID
|
|
-99999999999
|
|
|
|
ResourceLabel
|
Resource Label
|
|
x(60)
|
|
|
|
ResourceType
|
Type
|
|
x(1)
|
|
|
|
ResourceURI
|
Universal Resource Identification
|
URI
|
x(256)
|
|
|
|
SODcategory_ID
|
link to SOD Category
|
|
-99999999999
|
|
|
|
Index-Name
|
Uni
|
Field-Name
|
Asc
|
Abbr
|
|
|
BusActivity_FK
|
no
|
BusActivity_ID
|
yes
|
no
|
|
∗
|
Resource_PK
|
yes
|
Resource_ID
|
yes
|
no
|
|
|
SODcategory
|
no
|
SODcategory_ID
|
yes
|
no
|
|
|
Type
|
no
|
ResourceType
|
yes
|
no
|
|
|
URI
|
yes
|
ResourceURI
|
yes
|
no
|
|
|
Field Name
|
Label
|
Col-Label
|
Format
|
Dec
|
|
|
CCRevalPosting_ID
|
Link to Posting
|
|
-99999999999
|
|
|
|
CCReversePosting_ID
|
Link to Posting
|
|
-99999999999
|
|
|
|
CCUndoPosting_ID
|
Link to Posting
|
|
-99999999999
|
|
|
|
CCUndoReversePosting_ID
|
Link to Posting
|
|
-99999999999
|
|
|
|
LastModifiedDate
|
Last Modified Date
|
Mod Date
|
99/99/9999
|
|
|
|
LastModifiedTime
|
Last Modified Time
|
Mod Time
|
99999
|
|
|
|
LastModifiedUser
|
Last Modified User
|
Mod User
|
x(20)
|
|
|
|
QADC01
|
|
|
x(40)
|
|
|
|
QADC02
|
|
|
x(255)
|
|
|
|
QADD01
|
|
|
->,>>>,>>9.9999
|
10
|
|
|
QADT01
|
|
|
99/99/9999
|
|
|
|
Reval_ID
|
Record ID
|
|
-99999999999
|
|
|
|
RevalHeader_ID
|
Link to RevalHeader
|
|
-99999999999
|
|
|
|
RevalRevaluationArea
|
Revaluation Area
|
|
x(20)
|
|
|
|
RevalStatusCode
|
Status
|
|
x(20)
|
|
|
|
TCRevalPosting_ID
|
Link to Posting
|
|
-99999999999
|
|
|
|
TCReversePosting_ID
|
Link to Posting
|
|
-99999999999
|
|
|
|
TCUndoPosting_ID
|
Link to Posting
|
|
-99999999999
|
|
|
|
TCUndoReversePosting_ID
|
Voucher
|
|
-99999999999
|
|
|
|
Index-Name
|
Uni
|
Field-Name
|
Asc
|
Abbr
|
|
|
CCRevalPosting
|
no
|
CCRevalPosting_ID
|
yes
|
no
|
|
|
CCReversePosting
|
no
|
CCReversePosting_ID
|
yes
|
no
|
|
|
CCUndoPosting
|
no
|
CCUndoPosting_ID
|
yes
|
no
|
|
|
CCUndoReversePosting
|
no
|
CCUndoReversePosting_ID
|
yes
|
no
|
|
∗
|
Prim
|
yes
|
Reval_ID
|
yes
|
no
|
|
|
RevalArea
|
no
|
RevalRevaluationArea
|
yes
|
no
|
|
|
RevalHeader
|
no
|
RevalHeader_ID
|
yes
|
no
|
|
|
RevalStatus
|
no
|
RevalStatusCode
|
yes
|
no
|
|
|
TCRevalPosting
|
no
|
TCRevalPosting_ID
|
yes
|
no
|
|
|
TCReverseposting
|
no
|
TCReversePosting_ID
|
yes
|
no
|
|
|
TCUndoPosting
|
no
|
TCUndoPosting_ID
|
yes
|
no
|
|
|
TCUndoReversePosting
|
no
|
TCUndoReversePosting_ID
|
yes
|
no
|
|
|
UniqueIdx
|
yes
|
RevalRevaluationArea
|
yes
|
no
|
|
|
|
|
RevalHeader_ID
|
yes
|
no
|
|
|
Field Name
|
Label
|
Col-Label
|
Format
|
Dec
|
|
|
LastModifiedDate
|
Last Modified Date
|
Mod Date
|
99/99/9999
|
|
|
|
LastModifiedTime
|
Last Modified Time
|
Mod Time
|
99999
|
|
|
|
LastModifiedUser
|
Last Modified User
|
Mod User
|
x(20)
|
|
|
|
QADC01
|
|
|
x(40)
|
|
|
|
QADC02
|
|
|
x(255)
|
|
|
|
QADD01
|
|
|
->,>>>,>>9.9999
|
10
|
|
|
QADT01
|
|
|
99/99/9999
|
|
|
|
RevalDet_ID
|
Record ID
|
|
-99999999999
|
|
|
|
RevalDetCCExchangeRate
|
SC Exchange Rate
|
|
->,>>>,>>9.9999999999
|
10
|
|
|
RevalDetCCExchangeScale
|
SC Exchange Rate Scale
|
|
->,>>>,>>9.9999999999
|
10
|
|
|
RevalDetCreditCC
|
SC Credit
|
|
->>>,>>>,>>>,>>9.99
|
4
|
|
|
RevalDetCreditLC
|
BC Credit
|
|
->>>,>>>,>>>,>>9.99
|
4
|
|
|
RevalDetCreditTC
|
TC Credit
|
|
->>>,>>>,>>>,>>9.99
|
4
|
|
|
RevalDetDebitCC
|
SC Debit
|
|
->>>,>>>,>>>,>>9.99
|
4
|
|
|
RevalDetDebitLC
|
BC Debit
|
|
->>>,>>>,>>>,>>9.99
|
4
|
|
|
RevalDetDebitTC
|
TC Debit
|
|
->>>,>>>,>>>,>>9.99
|
4
|
|
|
RevalDetParentObject_ID
|
Link to ParentObject
|
|
-99999999999
|
|
|
|
RevalDetParentObjectType
|
Object Type
|
|
x(20)
|
|
|
|
RevalDetRevCreditCC
|
SC Revaluated Credit
|
SC Rev Credit
|
->>>,>>>,>>>,>>9.99
|
4
|
|
|
RevalDetRevCreditLC
|
BC Revaluated Credit
|
BC Rev Credit
|
->>>,>>>,>>>,>>9.99
|
4
|
|
|
RevalDetRevDebitCC
|
SC Revaluated Debit
|
SC Rev Debit
|
->>>,>>>,>>>,>>9.99
|
4
|
|
|
RevalDetRevDebitLC
|
BC Revaluated Debit
|
BC Rev Debit
|
->>>,>>>,>>>,>>9.99
|
4
|
|
|
RevalDetTCExchangeRate
|
BC Exchange Rate
|
|
->,>>>,>>9.9999999999
|
10
|
|
|
RevalDetTCExchangeScale
|
BC Exchange Rate Scale
|
|
->,>>>,>>9.9999999999
|
10
|
|
|
RevalGL_ID
|
Link to RevalGL
|
|
-99999999999
|
|
|
|
RevalHeader_ID
|
Link to RevalHeader
|
|
-99999999999
|
|
|
|
Index-Name
|
Uni
|
Field-Name
|
Asc
|
Abbr
|
|
|
ParentObject
|
no
|
RevalDetParentObject_ID
|
yes
|
no
|
|
|
ParentType
|
no
|
RevalDetParentObjectType
|
yes
|
no
|
|
∗
|
Prim
|
yes
|
RevalDet_ID
|
yes
|
no
|
|
|
RevalGL
|
no
|
RevalGL_ID
|
yes
|
no
|
|
|
RevHead
|
no
|
RevalHeader_ID
|
yes
|
no
|
|
|
Field Name
|
Label
|
Col-Label
|
Format
|
Dec
|
|
|
CCExchangeRateType_ID
|
Exchange Rate Type
|
Rate Type
|
-99999999999
|
|
|
|
CostCentre_ID
|
Cost Center
|
|
-99999999999
|
|
|
|
Currency_ID
|
Currency Code
|
Curr
|
-99999999999
|
|
|
|
Division_ID
|
Sub-Account
|
Sub-Acct
|
-99999999999
|
|
|
|
GL_ID
|
GL Account
|
|
-99999999999
|
|
|
|
IntercoBusinessRelation_ID
|
Business Relation
|
Business Relation Code
|
-99999999999
|
|
|
|
LastModifiedDate
|
Last Modified Date
|
Mod Date
|
99/99/9999
|
|
|
|
LastModifiedTime
|
Last Modified Time
|
Mod Time
|
99999
|
|
|
|
LastModifiedUser
|
Last Modified User
|
Mod User
|
x(20)
|
|
|
|
Project_ID
|
Project
|
|
-99999999999
|
|
|
|
QADC01
|
|
|
x(40)
|
|
|
|
QADC02
|
|
|
x(255)
|
|
|
|
QADD01
|
|
|
->,>>>,>>9.9999
|
10
|
|
|
QADT01
|
|
|
99/99/9999
|
|
|
|
Reval_ID
|
Link to Reval
|
|
-99999999999
|
|
|
|
RevalGL_ID
|
Record ID
|
|
-99999999999
|
|
|
|
RevalGLCCExchangeRate
|
SC Exchange Rate
|
|
->,>>>,>>9.9999999999
|
10
|
|
|
RevalGLCCExchangeRateScale
|
SC Exchange Rate Scale
|
|
->,>>>,>>9.9999999999
|
10
|
|
|
RevalGLCreditCC
|
SC Credit
|
|
->>>,>>>,>>>,>>9.99
|
4
|
|
|
RevalGLCreditLC
|
BC Credit
|
|
->>>,>>>,>>>,>>9.99
|
4
|
|
|
RevalGLCreditTC
|
TC Credit
|
|
->>>,>>>,>>>,>>9.99
|
4
|
|
|
RevalGLDebitCC
|
SC Debit
|
|
->>>,>>>,>>>,>>9.99
|
4
|
|
|
RevalGLDebitLC
|
BC Debit
|
|
->>>,>>>,>>>,>>9.99
|
4
|
|
|
RevalGLDebitTC
|
TC Debit
|
|
->>>,>>>,>>>,>>9.99
|
4
|
|
|
RevalGLMethodCC
|
SC Revaluation Method
|
SC Rev Method
|
x(20)
|
|
|
|
RevalGLMethodTC
|
TC Revaluation Method
|
TC Rev Method
|
x(20)
|
|
|
|
RevalGLRevCreditCC
|
SC Revaluated Credit
|
SC Rev Credit
|
->>>,>>>,>>>,>>9.99
|
4
|
|
|
RevalGLRevCreditLC
|
BC Revaluated Credit
|
BC Rev Credit
|
->>>,>>>,>>>,>>9.99
|
4
|
|
|
RevalGLRevDebitCC
|
SC Revaluated Debit
|
SC Rev Debit
|
->>>,>>>,>>>,>>9.99
|
4
|
|
|
RevalGLRevDebitLC
|
BC Revaluated Debit
|
BC Rev Debit
|
->>>,>>>,>>>,>>9.99
|
4
|
|
|
RevalGLSafCombined_ID
|
Link to RevalGLSafCombined
|
|
-99999999999
|
|
|
|
RevalGLTCExchangeRate
|
BC Exchange Rate
|
|
->,>>>,>>9.9999999999
|
10
|
|
|
RevalGLTCExchangeRateScale
|
BC Exchange Rate Scale
|
|
->,>>>,>>9.9999999999
|
10
|
|
|
RevalGLType
|
GL Type
|
|
x(20)
|
|
|
|
RevalHeader_ID
|
Link to RevalHeader
|
|
-99999999999
|
|
|
|
TCExchangeRateType_ID
|
TC Revaluation Rate
|
Rev Rate TC
|
-99999999999
|
|
|
|
Index-Name
|
Uni
|
Field-Name
|
Asc
|
Abbr
|
|
|
CCExRateTpIdx
|
no
|
CCExchangeRateType_ID
|
yes
|
no
|
|
|
CostCentre
|
no
|
CostCentre_ID
|
yes
|
no
|
|
|
Currency
|
no
|
Currency_ID
|
yes
|
no
|
|
|
Division
|
no
|
Division_ID
|
yes
|
no
|
|
|
GL
|
no
|
GL_ID
|
yes
|
no
|
|
|
Interco
|
no
|
IntercoBusinessRelation_ID
|
yes
|
no
|
|
∗
|
Prim
|
yes
|
RevalGL_ID
|
yes
|
no
|
|
|
Project
|
no
|
Project_ID
|
yes
|
no
|
|
|
Reval
|
no
|
Reval_ID
|
yes
|
no
|
|
|
RevHead
|
no
|
RevalHeader_ID
|
yes
|
no
|
|
|
SafCombined
|
no
|
RevalGLSafCombined_ID
|
yes
|
no
|
|
|
TCExRateTpIdx
|
no
|
TCExchangeRateType_ID
|
yes
|
no
|
|
|
Type
|
no
|
RevalGLType
|
yes
|
no
|
|
|
Field Name
|
Label
|
Col-Label
|
Format
|
Dec
|
|
|
CostCentre1Saf_ID
|
Link to Saf
|
|
-99999999999
|
|
|
|
CostCentre2Saf_ID
|
Link to Saf
|
|
-99999999999
|
|
|
|
CostCentre3Saf_ID
|
Link to Saf
|
|
-99999999999
|
|
|
|
CostCentre4Saf_ID
|
Link to Saf
|
|
-99999999999
|
|
|
|
CostCentre5Saf_ID
|
Link to Saf
|
|
-99999999999
|
|
|
|
CostCentreSafStructure_ID
|
Link to SafStructure
|
|
-99999999999
|
|
|
|
GL1Saf_ID
|
Link to Saf
|
|
-99999999999
|
|
|
|
GL2Saf_ID
|
Link to Saf
|
|
-99999999999
|
|
|
|
GL3Saf_ID
|
Link to Saf
|
|
-99999999999
|
|
|
|
GL4Saf_ID
|
Link to Saf
|
|
-99999999999
|
|
|
|
GL5Saf_ID
|
Link to Saf
|
|
-99999999999
|
|
|
|
GLSafStructure_ID
|
Link to SafStructure
|
|
-99999999999
|
|
|
|
LastModifiedDate
|
Last Modified Date
|
Mod Date
|
99/99/9999
|
|
|
|
LastModifiedTime
|
Last Modified Time
|
Mod Time
|
99999
|
|
|
|
LastModifiedUser
|
Last Modified User
|
Mod User
|
x(20)
|
|
|
|
Project1Saf_ID
|
Link to Saf
|
|
-99999999999
|
|
|
|
Project2Saf_ID
|
Link to Saf
|
|
-99999999999
|
|
|
|
Project3Saf_ID
|
Link to Saf
|
|
-99999999999
|
|
|
|
Project4Saf_ID
|
Link to Saf
|
|
-99999999999
|
|
|
|
Project5Saf_ID
|
Link to Saf
|
|
-99999999999
|
|
|
|
ProjectSafStructure_ID
|
Link to SafStructure
|
|
-99999999999
|
|
|
|
QADC01
|
|
|
x(40)
|
|
|
|
QADC02
|
|
|
x(255)
|
|
|
|
QADD01
|
|
|
->,>>>,>>9.9999
|
10
|
|
|
QADT01
|
|
|
99/99/9999
|
|
|
|
RevalGLSafCombined_ID
|
Record ID
|
|
-99999999999
|
|
|
|
Index-Name
|
Uni
|
Field-Name
|
Asc
|
Abbr
|
|
|
CC1Idx
|
no
|
CostCentre1Saf_ID
|
yes
|
no
|
|
|
CC2Idx
|
no
|
CostCentre2Saf_ID
|
yes
|
no
|
|
|
CC3Idx
|
no
|
CostCentre3Saf_ID
|
yes
|
no
|
|
|
CC4Idx
|
no
|
CostCentre4Saf_ID
|
yes
|
no
|
|
|
CC5Idx
|
no
|
CostCentre5Saf_ID
|
yes
|
no
|
|
|
CCStrIdx
|
no
|
CostCentreSafStructure_ID
|
yes
|
no
|
|
|
GL1Idx
|
no
|
GL1Saf_ID
|
yes
|
no
|
|
|
GL2Idx
|
no
|
GL2Saf_ID
|
yes
|
no
|
|
|
GL3Idx
|
no
|
GL3Saf_ID
|
yes
|
no
|
|
|
GL4Idx
|
no
|
GL4Saf_ID
|
yes
|
no
|
|
|
GL5Idx
|
no
|
GL5Saf_ID
|
yes
|
no
|
|
|
GLStrIdx
|
no
|
GLSafStructure_ID
|
yes
|
no
|
|
∗
|
Prim
|
yes
|
RevalGLSafCombined_ID
|
yes
|
no
|
|
|
Prj1Idx
|
no
|
Project1Saf_ID
|
yes
|
no
|
|
|
Prj2Idx
|
no
|
Project2Saf_ID
|
yes
|
no
|
|
|
Prj3Idx
|
no
|
Project3Saf_ID
|
yes
|
no
|
|
|
Prj4Idx
|
no
|
Project4Saf_ID
|
yes
|
no
|
|
|
Prj5Idx
|
no
|
Project5Saf_ID
|
yes
|
no
|
|
|
PrjStrIdx
|
no
|
ProjectSafStructure_ID
|
yes
|
no
|
|
|
Field Name
|
Label
|
Col-Label
|
Format
|
Dec
|
|
|
Company_ID
|
Link to Company
|
|
-99999999999
|
|
|
|
LastModifiedDate
|
Last Modified Date
|
Mod Date
|
99/99/9999
|
|
|
|
LastModifiedTime
|
Last Modified Time
|
Mod Time
|
99999
|
|
|
|
LastModifiedUser
|
Last Modified User
|
Mod User
|
x(20)
|
|
|
|
Layer_ID
|
Layer Code
|
|
-99999999999
|
|
|
|
Period_ID
|
GL Cal Year
|
|
-99999999999
|
|
|
|
QADC01
|
|
|
x(40)
|
|
|
|
QADC02
|
|
|
x(255)
|
|
|
|
QADD01
|
|
|
->,>>>,>>9.9999
|
10
|
|
|
QADT01
|
|
|
99/99/9999
|
|
|
|
RevalHeader_ID
|
Record ID
|
|
-99999999999
|
|
|
|
RevalHeaderDescription
|
Rev Desc
|
|
x(40)
|
|
|
|
RevalHeaderIsForCC
|
Include Statutory Currency
|
|
yes/no
|
|
|
|
RevalHeaderIsForLC
|
Include Base Currency
|
|
yes/no
|
|
|
|
RevalHeaderNumber
|
Rev Number
|
|
999999999
|
|
|
|
RevalHeaderRevalDate
|
Rev Date
|
|
99/99/9999
|
|
|
|
Source1Layer_ID
|
Link to Source Layer 1
|
|
-99999999999
|
|
|
|
Source2Layer_ID
|
Link to Source Layer 2
|
|
-99999999999
|
|
|
|
Source3Layer_ID
|
Link to Source Layer 3
|
|
-99999999999
|
|
|
|
Index-Name
|
Uni
|
Field-Name
|
Asc
|
Abbr
|
|
|
Company
|
no
|
Company_ID
|
yes
|
no
|
|
|
Layer
|
no
|
Layer_ID
|
yes
|
no
|
|
|
Period
|
no
|
Period_ID
|
yes
|
no
|
|
∗
|
Prim
|
yes
|
RevalHeader_ID
|
yes
|
no
|
|
|
RevalDate
|
no
|
RevalHeaderRevalDate
|
yes
|
no
|
|
|
RevalNumber
|
no
|
RevalHeaderNumber
|
yes
|
no
|
|
|
SourceLayer1
|
no
|
Source1Layer_ID
|
yes
|
no
|
|
|
SourceLayer2
|
no
|
Source2Layer_ID
|
yes
|
no
|
|
|
SourceLayer3
|
no
|
Source3Layer_ID
|
yes
|
no
|
|
|
UniqueIdx
|
yes
|
Company_ID
|
yes
|
no
|
|
|
|
|
Period_ID
|
yes
|
no
|
|
|
|
|
RevalHeaderNumber
|
yes
|
no
|
|
|
Field Name
|
Label
|
Col-Label
|
Format
|
Dec
|
|
|
ExchangeRateType_ID
|
Exchange Rate Type
|
Rate Type
|
-99999999999
|
|
|
|
FromCurrency_ID
|
Currency Code
|
Curr
|
-99999999999
|
|
|
|
LastModifiedDate
|
Last Modified Date
|
Mod Date
|
99/99/9999
|
|
|
|
LastModifiedTime
|
Last Modified Time
|
Mod Time
|
99999
|
|
|
|
LastModifiedUser
|
Last Modified User
|
Mod User
|
x(20)
|
|
|
|
QADC01
|
|
|
x(40)
|
|
|
|
QADC02
|
|
|
x(255)
|
|
|
|
QADD01
|
|
|
->,>>>,>>9.9999
|
10
|
|
|
QADT01
|
|
|
99/99/9999
|
|
|
|
RevalHeader_ID
|
Link to RevalHeader
|
|
-99999999999
|
|
|
|
RevalRate_ID
|
Record ID
|
|
-99999999999
|
|
|
|
RevalRateDate
|
Revaluation Rate Date
|
Rev Rate Date
|
99/99/9999
|
|
|
|
RevalRateExchageRateScale
|
Scale Fact
|
|
->,>>>,>>9.9999999999
|
10
|
|
|
RevalRateExchangeRate
|
Revaluation Rate
|
Rev Rate
|
->,>>>,>>9.9999999999
|
10
|
|
|
ToCurrency_ID
|
Currency Code
|
Curr
|
-99999999999
|
|
|
|
Index-Name
|
Uni
|
Field-Name
|
Asc
|
Abbr
|
|
|
ExRateTpIdx
|
no
|
ExchangeRateType_ID
|
yes
|
no
|
|
|
FromCurrIdx
|
no
|
FromCurrency_ID
|
yes
|
no
|
|
∗
|
Prim
|
yes
|
RevalRate_ID
|
yes
|
no
|
|
|
RevalHeader
|
no
|
RevalHeader_ID
|
yes
|
no
|
|
|
ToCurrIdx
|
no
|
ToCurrency_ID
|
yes
|
no
|