|
|
Field Name
|
Label
|
Col-Label
|
Format
|
Dec
|
|
|
CustomCombo0
|
|
|
x(20)
|
|
|
|
CustomCombo1
|
|
|
x(20)
|
|
|
|
CustomCombo2
|
|
|
x(20)
|
|
|
|
CustomCombo3
|
|
|
x(20)
|
|
|
|
CustomCombo4
|
|
|
x(20)
|
|
|
|
CustomCombo5
|
|
|
x(20)
|
|
|
|
CustomCombo6
|
|
|
x(20)
|
|
|
|
CustomCombo7
|
|
|
x(20)
|
|
|
|
CustomCombo8
|
|
|
x(20)
|
|
|
|
CustomCombo9
|
|
|
x(20)
|
|
|
|
CustomDate0
|
|
|
99/99/9999
|
|
|
|
CustomDate1
|
|
|
99/99/9999
|
|
|
|
CustomDate2
|
|
|
99/99/9999
|
|
|
|
CustomDate3
|
|
|
99/99/9999
|
|
|
|
CustomDate4
|
|
|
99/99/9999
|
|
|
|
CustomDecimal0
|
|
|
->,>>>,>>9.99
|
4
|
|
|
CustomDecimal1
|
|
|
->,>>>,>>9.99
|
4
|
|
|
CustomDecimal2
|
|
|
->,>>>,>>9.99
|
4
|
|
|
CustomDecimal3
|
|
|
->,>>>,>>9.99
|
4
|
|
|
CustomDecimal4
|
|
|
->,>>>,>>9.99
|
4
|
|
|
CustomInteger0
|
|
|
->,>>>,>>9
|
|
|
|
CustomInteger1
|
|
|
->,>>>,>>9
|
|
|
|
CustomInteger2
|
|
|
->,>>>,>>9
|
|
|
|
CustomInteger3
|
|
|
->,>>>,>>9
|
|
|
|
CustomInteger4
|
|
|
->,>>>,>>9
|
|
|
|
CustomLong0
|
|
|
x(255)
|
|
|
|
CustomLong1
|
|
|
x(255)
|
|
|
|
CustomNote
|
|
|
x(2000)
|
|
|
|
CustomShort0
|
|
|
x(20)
|
|
|
|
CustomShort1
|
|
|
x(20)
|
|
|
|
CustomShort2
|
|
|
x(20)
|
|
|
|
CustomShort3
|
|
|
x(20)
|
|
|
|
CustomShort4
|
|
|
x(20)
|
|
|
|
CustomShort5
|
|
|
x(20)
|
|
|
|
CustomShort6
|
|
|
x(20)
|
|
|
|
CustomShort7
|
|
|
x(20)
|
|
|
|
CustomShort8
|
|
|
x(20)
|
|
|
|
CustomShort9
|
|
|
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)
|
|
|
|
QADC03
|
|
|
x(40)
|
|
|
|
QADC04
|
|
|
x(40)
|
|
|
|
QADC05
|
|
|
x(40)
|
|
|
|
QADC06
|
|
|
x(40)
|
|
|
|
QADD01
|
|
|
->,>>>,>>9.9999
|
10
|
|
|
QADD02
|
|
|
->,>>>,>>9.9999
|
10
|
|
|
QADD03
|
|
|
->,>>>,>>9.9999
|
10
|
|
|
QADD04
|
|
|
->,>>>,>>9.9999
|
10
|
|
|
QADD05
|
|
|
->,>>>,>>9.9999
|
10
|
|
|
QADD06
|
|
|
->,>>>,>>9.9999
|
10
|
|
|
QADL01
|
|
|
yes/no
|
|
|
|
QADL02
|
|
|
yes/no
|
|
|
|
QADL03
|
|
|
yes/no
|
|
|
|
QADL04
|
|
|
yes/no
|
|
|
|
QADL05
|
|
|
yes/no
|
|
|
|
QADL06
|
|
|
yes/no
|
|
|
|
QADT01
|
|
|
99/99/9999
|
|
|
|
QADT02
|
|
|
99/99/9999
|
|
|
|
QADT03
|
|
|
99/99/9999
|
|
|
|
QADT04
|
|
|
99/99/9999
|
|
|
|
QADT05
|
|
|
99/99/9999
|
|
|
|
QADT06
|
|
|
99/99/9999
|
|
|
|
RRContract_ID
|
Link to Revenue contract
|
|
-99999999999
|
|
|
|
RRContrRev_ID
|
Record ID
|
|
-99999999999
|
|
|
|
RRContrRevDate
|
Review Date
|
|
99/99/9999
|
|
|
|
RRContrRevNote
|
Note
|
|
x(2000)
|
|
|
|
RRContrRevRequestNote
|
Note of the review request
|
|
x(255)
|
|
|
|
RRContrRevRequestReasoning
|
Code of the review request
|
|
x(20)
|
|
|
|
RRContrRevResult
|
Review Result
|
|
x(20)
|
|
|
|
RRContrRevTime
|
Review Time
|
|
99999
|
|
|
|
RRContrRevUser
|
Review User
|
|
x(20)
|
|
|
|
RRContrVer_ID
|
Link to Contract version
|
|
-99999999999
|
|
|
|
Index-Name
|
Uni
|
Field-Name
|
Asc
|
Abbr
|
|
∗
|
Prim
|
yes
|
RRContrRev_ID
|
yes
|
no
|
|
|
RRContr
|
no
|
RRContract_ID
|
yes
|
no
|
|
|
RRContrVer
|
no
|
RRContrVer_ID
|
yes
|
no
|
|
|
UniqueIdx
|
yes
|
RRContract_ID
|
yes
|
no
|
|
|
|
|
RRContrVer_ID
|
yes
|
no
|
|
|
|
|
RRContrRevUser
|
yes
|
no
|
|
|
|
|
RRContrRevDate
|
yes
|
no
|
|
|
|
|
RRContrRevTime
|
yes
|
no
|
|
|
Field Name
|
Label
|
Col-Label
|
Format
|
Dec
|
|
|
CustomCombo0
|
|
|
x(20)
|
|
|
|
CustomCombo1
|
|
|
x(20)
|
|
|
|
CustomCombo2
|
|
|
x(20)
|
|
|
|
CustomCombo3
|
|
|
x(20)
|
|
|
|
CustomCombo4
|
|
|
x(20)
|
|
|
|
CustomCombo5
|
|
|
x(20)
|
|
|
|
CustomCombo6
|
|
|
x(20)
|
|
|
|
CustomCombo7
|
|
|
x(20)
|
|
|
|
CustomCombo8
|
|
|
x(20)
|
|
|
|
CustomCombo9
|
|
|
x(20)
|
|
|
|
CustomDate0
|
|
|
99/99/9999
|
|
|
|
CustomDate1
|
|
|
99/99/9999
|
|
|
|
CustomDate2
|
|
|
99/99/9999
|
|
|
|
CustomDate3
|
|
|
99/99/9999
|
|
|
|
CustomDate4
|
|
|
99/99/9999
|
|
|
|
CustomDecimal0
|
|
|
->,>>>,>>9.99
|
4
|
|
|
CustomDecimal1
|
|
|
->,>>>,>>9.99
|
4
|
|
|
CustomDecimal2
|
|
|
->,>>>,>>9.99
|
4
|
|
|
CustomDecimal3
|
|
|
->,>>>,>>9.99
|
4
|
|
|
CustomDecimal4
|
|
|
->,>>>,>>9.99
|
4
|
|
|
CustomInteger0
|
|
|
->,>>>,>>9
|
|
|
|
CustomInteger1
|
|
|
->,>>>,>>9
|
|
|
|
CustomInteger2
|
|
|
->,>>>,>>9
|
|
|
|
CustomInteger3
|
|
|
->,>>>,>>9
|
|
|
|
CustomInteger4
|
|
|
->,>>>,>>9
|
|
|
|
CustomLong0
|
|
|
x(255)
|
|
|
|
CustomLong1
|
|
|
x(255)
|
|
|
|
CustomNote
|
|
|
x(2000)
|
|
|
|
CustomShort0
|
|
|
x(20)
|
|
|
|
CustomShort1
|
|
|
x(20)
|
|
|
|
CustomShort2
|
|
|
x(20)
|
|
|
|
CustomShort3
|
|
|
x(20)
|
|
|
|
CustomShort4
|
|
|
x(20)
|
|
|
|
CustomShort5
|
|
|
x(20)
|
|
|
|
CustomShort6
|
|
|
x(20)
|
|
|
|
CustomShort7
|
|
|
x(20)
|
|
|
|
CustomShort8
|
|
|
x(20)
|
|
|
|
CustomShort9
|
|
|
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)
|
|
|
|
QADC03
|
|
|
x(40)
|
|
|
|
QADC04
|
|
|
x(40)
|
|
|
|
QADC05
|
|
|
x(40)
|
|
|
|
QADC06
|
|
|
x(40)
|
|
|
|
QADD01
|
|
|
->,>>>,>>9.9999
|
10
|
|
|
QADD02
|
|
|
->,>>>,>>9.9999
|
10
|
|
|
QADD03
|
|
|
->,>>>,>>9.9999
|
10
|
|
|
QADD04
|
|
|
->,>>>,>>9.9999
|
10
|
|
|
QADD05
|
|
|
->,>>>,>>9.9999
|
10
|
|
|
QADD06
|
|
|
->,>>>,>>9.9999
|
10
|
|
|
QADL01
|
|
|
yes/no
|
|
|
|
QADL02
|
|
|
yes/no
|
|
|
|
QADL03
|
|
|
yes/no
|
|
|
|
QADL04
|
|
|
yes/no
|
|
|
|
QADL05
|
|
|
yes/no
|
|
|
|
QADL06
|
|
|
yes/no
|
|
|
|
QADT01
|
|
|
99/99/9999
|
|
|
|
QADT02
|
|
|
99/99/9999
|
|
|
|
QADT03
|
|
|
99/99/9999
|
|
|
|
QADT04
|
|
|
99/99/9999
|
|
|
|
QADT05
|
|
|
99/99/9999
|
|
|
|
QADT06
|
|
|
99/99/9999
|
|
|
|
RRContract_ID
|
Link to RRContract
|
|
-99999999999
|
|
|
|
RRContractLink_ID
|
Link to RRContractLink
|
|
-99999999999
|
|
|
|
RRContrHdr_ID
|
Link to Contract header
|
|
-99999999999
|
|
|
|
RRContrSafDef_ID
|
Record_ID
|
|
-99999999999
|
|
|
|
RRContrSafDefIsAutoCreated
|
Auto-Created
|
|
yes/no
|
|
|
|
RRContrVer_ID
|
Link to Contract version
|
|
-99999999999
|
|
|
|
Saf_ID
|
Link to Saf
|
|
-99999999999
|
|
|
|
SafConcept_ID
|
Link to SafConcept (Obsolete)
|
|
-99999999999
|
|
|
|
Index-Name
|
Uni
|
Field-Name
|
Asc
|
Abbr
|
|
|
CHdrIdx
|
no
|
RRContrHdr_ID
|
yes
|
no
|
|
|
ContIdx
|
no
|
RRContract_ID
|
yes
|
no
|
|
|
CVerIdx
|
no
|
RRContrVer_ID
|
yes
|
no
|
|
∗
|
Prim
|
yes
|
RRContrSafDef_ID
|
yes
|
no
|
|
|
SafCIdx
|
no
|
SafConcept_ID
|
yes
|
no
|
|
|
SafIdx
|
no
|
Saf_ID
|
yes
|
no
|
|
|
UniqueIdx
|
yes
|
RRContractLink_ID
|
yes
|
no
|
|
|
|
|
Saf_ID
|
yes
|
no
|
|
|
Field Name
|
Label
|
Col-Label
|
Format
|
Dec
|
|
|
CustomCombo0
|
|
|
x(20)
|
|
|
|
CustomCombo1
|
|
|
x(20)
|
|
|
|
CustomCombo2
|
|
|
x(20)
|
|
|
|
CustomCombo3
|
|
|
x(20)
|
|
|
|
CustomCombo4
|
|
|
x(20)
|
|
|
|
CustomCombo5
|
|
|
x(20)
|
|
|
|
CustomCombo6
|
|
|
x(20)
|
|
|
|
CustomCombo7
|
|
|
x(20)
|
|
|
|
CustomCombo8
|
|
|
x(20)
|
|
|
|
CustomCombo9
|
|
|
x(20)
|
|
|
|
CustomDate0
|
|
|
99/99/9999
|
|
|
|
CustomDate1
|
|
|
99/99/9999
|
|
|
|
CustomDate2
|
|
|
99/99/9999
|
|
|
|
CustomDate3
|
|
|
99/99/9999
|
|
|
|
CustomDate4
|
|
|
99/99/9999
|
|
|
|
CustomDecimal0
|
|
|
->,>>>,>>9.99
|
4
|
|
|
CustomDecimal1
|
|
|
->,>>>,>>9.99
|
4
|
|
|
CustomDecimal2
|
|
|
->,>>>,>>9.99
|
4
|
|
|
CustomDecimal3
|
|
|
->,>>>,>>9.99
|
4
|
|
|
CustomDecimal4
|
|
|
->,>>>,>>9.99
|
4
|
|
|
CustomInteger0
|
|
|
->,>>>,>>9
|
|
|
|
CustomInteger1
|
|
|
->,>>>,>>9
|
|
|
|
CustomInteger2
|
|
|
->,>>>,>>9
|
|
|
|
CustomInteger3
|
|
|
->,>>>,>>9
|
|
|
|
CustomInteger4
|
|
|
->,>>>,>>9
|
|
|
|
CustomLong0
|
|
|
x(255)
|
|
|
|
CustomLong1
|
|
|
x(255)
|
|
|
|
CustomNote
|
|
|
x(2000)
|
|
|
|
CustomShort0
|
|
|
x(20)
|
|
|
|
CustomShort1
|
|
|
x(20)
|
|
|
|
CustomShort2
|
|
|
x(20)
|
|
|
|
CustomShort3
|
|
|
x(20)
|
|
|
|
CustomShort4
|
|
|
x(20)
|
|
|
|
CustomShort5
|
|
|
x(20)
|
|
|
|
CustomShort6
|
|
|
x(20)
|
|
|
|
CustomShort7
|
|
|
x(20)
|
|
|
|
CustomShort8
|
|
|
x(20)
|
|
|
|
CustomShort9
|
|
|
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)
|
|
|
|
QADC03
|
|
|
x(40)
|
|
|
|
QADC04
|
|
|
x(40)
|
|
|
|
QADC05
|
|
|
x(40)
|
|
|
|
QADC06
|
|
|
x(40)
|
|
|
|
QADD01
|
|
|
->,>>>,>>9.9999
|
10
|
|
|
QADD02
|
|
|
->,>>>,>>9.9999
|
10
|
|
|
QADD03
|
|
|
->,>>>,>>9.9999
|
10
|
|
|
QADD04
|
|
|
->,>>>,>>9.9999
|
10
|
|
|
QADD05
|
|
|
->,>>>,>>9.9999
|
10
|
|
|
QADD06
|
|
|
->,>>>,>>9.9999
|
10
|
|
|
QADL01
|
|
|
yes/no
|
|
|
|
QADL02
|
|
|
yes/no
|
|
|
|
QADL03
|
|
|
yes/no
|
|
|
|
QADL04
|
|
|
yes/no
|
|
|
|
QADL05
|
|
|
yes/no
|
|
|
|
QADL06
|
|
|
yes/no
|
|
|
|
QADT01
|
|
|
99/99/9999
|
|
|
|
QADT02
|
|
|
99/99/9999
|
|
|
|
QADT03
|
|
|
99/99/9999
|
|
|
|
QADT04
|
|
|
99/99/9999
|
|
|
|
QADT05
|
|
|
99/99/9999
|
|
|
|
QADT06
|
|
|
99/99/9999
|
|
|
|
RRContract_ID
|
Record ID
|
|
-99999999999
|
|
|
|
RRContrVer_ID
|
Record ID
|
|
-99999999999
|
|
|
|
RRContrVerDate
|
Date
|
Date
|
99/99/9999
|
|
|
|
RRContrVerIsCurrent
|
Current version
|
Current
|
yes/no
|
|
|
|
RRContrVerIsOnHold
|
Contract version is on hold
|
|
yes/no
|
|
|
|
RRContrVerIsToBeReviewed
|
Review Required
|
Current
|
yes/no
|
|
|
|
RRContrVerNote
|
Note
|
Note
|
x(255)
|
|
|
|
RRContrVerReviewNote
|
Review Note
|
Review Note
|
x(2000)
|
|
|
|
RRContrVerReviewReasoning
|
Review Reason
|
Review Reason
|
x(20)
|
|
|
|
RRContrVerUser
|
User
|
User
|
x(20)
|
|
|
|
Index-Name
|
Uni
|
Field-Name
|
Asc
|
Abbr
|
|
|
CurrentIdx
|
no
|
RRContract_ID
|
yes
|
no
|
|
|
|
|
RRContrVerIsCurrent
|
yes
|
no
|
|
∗
|
Prim
|
yes
|
RRContrVer_ID
|
yes
|
no
|
|
|
Field Name
|
Label
|
Col-Label
|
Format
|
Dec
|
|
|
CustomCombo0
|
|
|
x(20)
|
|
|
|
CustomCombo1
|
|
|
x(20)
|
|
|
|
CustomCombo2
|
|
|
x(20)
|
|
|
|
CustomCombo3
|
|
|
x(20)
|
|
|
|
CustomCombo4
|
|
|
x(20)
|
|
|
|
CustomCombo5
|
|
|
x(20)
|
|
|
|
CustomCombo6
|
|
|
x(20)
|
|
|
|
CustomCombo7
|
|
|
x(20)
|
|
|
|
CustomCombo8
|
|
|
x(20)
|
|
|
|
CustomCombo9
|
|
|
x(20)
|
|
|
|
CustomDate0
|
|
|
99/99/9999
|
|
|
|
CustomDate1
|
|
|
99/99/9999
|
|
|
|
CustomDate2
|
|
|
99/99/9999
|
|
|
|
CustomDate3
|
|
|
99/99/9999
|
|
|
|
CustomDate4
|
|
|
99/99/9999
|
|
|
|
CustomDecimal0
|
|
|
->,>>>,>>9.99
|
4
|
|
|
CustomDecimal1
|
|
|
->,>>>,>>9.99
|
4
|
|
|
CustomDecimal2
|
|
|
->,>>>,>>9.99
|
4
|
|
|
CustomDecimal3
|
|
|
->,>>>,>>9.99
|
4
|
|
|
CustomDecimal4
|
|
|
->,>>>,>>9.99
|
4
|
|
|
CustomInteger0
|
|
|
->,>>>,>>9
|
|
|
|
CustomInteger1
|
|
|
->,>>>,>>9
|
|
|
|
CustomInteger2
|
|
|
->,>>>,>>9
|
|
|
|
CustomInteger3
|
|
|
->,>>>,>>9
|
|
|
|
CustomInteger4
|
|
|
->,>>>,>>9
|
|
|
|
CustomLong0
|
|
|
x(255)
|
|
|
|
CustomLong1
|
|
|
x(255)
|
|
|
|
CustomNote
|
|
|
x(2000)
|
|
|
|
CustomShort0
|
|
|
x(20)
|
|
|
|
CustomShort1
|
|
|
x(20)
|
|
|
|
CustomShort2
|
|
|
x(20)
|
|
|
|
CustomShort3
|
|
|
x(20)
|
|
|
|
CustomShort4
|
|
|
x(20)
|
|
|
|
CustomShort5
|
|
|
x(20)
|
|
|
|
CustomShort6
|
|
|
x(20)
|
|
|
|
CustomShort7
|
|
|
x(20)
|
|
|
|
CustomShort8
|
|
|
x(20)
|
|
|
|
CustomShort9
|
|
|
x(20)
|
|
|
|
Debtor_ID
|
Link to Debtor
|
|
-99999999999
|
|
|
|
Domain_ID
|
Link to Domains
|
|
-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)
|
|
|
|
QADC03
|
|
|
x(40)
|
|
|
|
QADC04
|
|
|
x(40)
|
|
|
|
QADC05
|
|
|
x(40)
|
|
|
|
QADC06
|
|
|
x(40)
|
|
|
|
QADD01
|
|
|
->,>>>,>>9.9999
|
10
|
|
|
QADD02
|
|
|
->,>>>,>>9.9999
|
10
|
|
|
QADD03
|
|
|
->,>>>,>>9.9999
|
10
|
|
|
QADD04
|
|
|
->,>>>,>>9.9999
|
10
|
|
|
QADD05
|
|
|
->,>>>,>>9.9999
|
10
|
|
|
QADD06
|
|
|
->,>>>,>>9.9999
|
10
|
|
|
QADL01
|
|
|
yes/no
|
|
|
|
QADL02
|
|
|
yes/no
|
|
|
|
QADL03
|
|
|
yes/no
|
|
|
|
QADL04
|
|
|
yes/no
|
|
|
|
QADL05
|
|
|
yes/no
|
|
|
|
QADL06
|
|
|
yes/no
|
|
|
|
QADT01
|
|
|
99/99/9999
|
|
|
|
QADT02
|
|
|
99/99/9999
|
|
|
|
QADT03
|
|
|
99/99/9999
|
|
|
|
QADT04
|
|
|
99/99/9999
|
|
|
|
QADT05
|
|
|
99/99/9999
|
|
|
|
QADT06
|
|
|
99/99/9999
|
|
|
|
RRDefaultRule_ID
|
Record ID
|
|
-99999999999
|
|
|
|
RRDefaultRuleItem
|
Item Number
|
|
x(18)
|
|
|
|
RRDefaultRuleShippingTerm
|
Shipping Term
|
|
x(20)
|
|
|
|
RRRule_ID
|
Link to RRRule
|
|
-99999999999
|
|
|
|
Index-Name
|
Uni
|
Field-Name
|
Asc
|
Abbr
|
|
∗
|
Prim
|
yes
|
RRDefaultRule_ID
|
yes
|
no
|
|
|
SearchIdx
|
no
|
Domain_ID
|
yes
|
no
|
|
|
|
|
Debtor_ID
|
yes
|
no
|
|
|
|
|
RRDefaultRuleItem
|
yes
|
no
|
|
|
|
|
RRDefaultRuleShippingTerm
|
yes
|
no
|
|
|
Field Name
|
Label
|
Col-Label
|
Format
|
Dec
|
|
|
AccruedCostCentre_ID
|
Link To CostCentre (Accrued)
|
|
-99999999999
|
|
|
|
AccruedDivision_ID
|
Link To Division (Accrued)
|
|
-99999999999
|
|
|
|
AccruedGL_ID
|
Link To GL (Accrued)
|
|
-99999999999
|
|
|
|
AccruedProject_ID
|
Link To Project (Accrued)
|
|
-99999999999
|
|
|
|
COGSDeferCostCentre_ID
|
Link to COGS Defer Cost centre
|
|
-99999999999
|
|
|
|
COGSDeferDivision_ID
|
Link to COGS Defer Sub-account
|
|
-99999999999
|
|
|
|
COGSDeferGL_ID
|
Link to COGS Defer GL account
|
|
-99999999999
|
|
|
|
COGSDeferProject_ID
|
Link to COGS Defer Project
|
|
-99999999999
|
|
|
|
COGSExpenseCostCentre_ID
|
Link to COGS Expense Cost centre
|
|
-99999999999
|
|
|
|
COGSExpenseDivision_ID
|
Link to COGS Expense Sub-account
|
|
-99999999999
|
|
|
|
COGSExpenseGL_ID
|
Link to COGS Expense GL account
|
|
-99999999999
|
|
|
|
COGSExpenseProject_ID
|
Link to COGS Expense Project
|
|
-99999999999
|
|
|
|
Company_ID
|
Link to Company
|
|
-99999999999
|
|
|
|
CustomCombo0
|
|
|
x(20)
|
|
|
|
CustomCombo1
|
|
|
x(20)
|
|
|
|
CustomCombo2
|
|
|
x(20)
|
|
|
|
CustomCombo3
|
|
|
x(20)
|
|
|
|
CustomCombo4
|
|
|
x(20)
|
|
|
|
CustomCombo5
|
|
|
x(20)
|
|
|
|
CustomCombo6
|
|
|
x(20)
|
|
|
|
CustomCombo7
|
|
|
x(20)
|
|
|
|
CustomCombo8
|
|
|
x(20)
|
|
|
|
CustomCombo9
|
|
|
x(20)
|
|
|
|
CustomDate0
|
|
|
99/99/9999
|
|
|
|
CustomDate1
|
|
|
99/99/9999
|
|
|
|
CustomDate2
|
|
|
99/99/9999
|
|
|
|
CustomDate3
|
|
|
99/99/9999
|
|
|
|
CustomDate4
|
|
|
99/99/9999
|
|
|
|
CustomDecimal0
|
|
|
->,>>>,>>9.99
|
4
|
|
|
CustomDecimal1
|
|
|
->,>>>,>>9.99
|
4
|
|
|
CustomDecimal2
|
|
|
->,>>>,>>9.99
|
4
|
|
|
CustomDecimal3
|
|
|
->,>>>,>>9.99
|
4
|
|
|
CustomDecimal4
|
|
|
->,>>>,>>9.99
|
4
|
|
|
CustomInteger0
|
|
|
->,>>>,>>9
|
|
|
|
CustomInteger1
|
|
|
->,>>>,>>9
|
|
|
|
CustomInteger2
|
|
|
->,>>>,>>9
|
|
|
|
CustomInteger3
|
|
|
->,>>>,>>9
|
|
|
|
CustomInteger4
|
|
|
->,>>>,>>9
|
|
|
|
CustomLong0
|
|
|
x(255)
|
|
|
|
CustomLong1
|
|
|
x(255)
|
|
|
|
CustomNote
|
|
|
x(2000)
|
|
|
|
CustomShort0
|
|
|
x(20)
|
|
|
|
CustomShort1
|
|
|
x(20)
|
|
|
|
CustomShort2
|
|
|
x(20)
|
|
|
|
CustomShort3
|
|
|
x(20)
|
|
|
|
CustomShort4
|
|
|
x(20)
|
|
|
|
CustomShort5
|
|
|
x(20)
|
|
|
|
CustomShort6
|
|
|
x(20)
|
|
|
|
CustomShort7
|
|
|
x(20)
|
|
|
|
CustomShort8
|
|
|
x(20)
|
|
|
|
CustomShort9
|
|
|
x(20)
|
|
|
|
DeferredCostCentre_ID
|
Link To CostCentre (Deferred)
|
|
-99999999999
|
|
|
|
DeferredDivision_ID
|
Link To Division (Deferred)
|
|
-99999999999
|
|
|
|
DeferredGL_ID
|
Link To GL (Deferred)
|
|
-99999999999
|
|
|
|
DeferredProject_ID
|
Link To Project (Deferred)
|
|
-99999999999
|
|
|
|
Domain_ID
|
Link to Domain
|
|
-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)
|
|
|
|
QADC03
|
|
|
x(40)
|
|
|
|
QADC04
|
|
|
x(40)
|
|
|
|
QADC05
|
|
|
x(40)
|
|
|
|
QADC06
|
|
|
x(40)
|
|
|
|
QADD01
|
|
|
->,>>>,>>9.9999
|
10
|
|
|
QADD02
|
|
|
->,>>>,>>9.9999
|
10
|
|
|
QADD03
|
|
|
->,>>>,>>9.9999
|
10
|
|
|
QADD04
|
|
|
->,>>>,>>9.9999
|
10
|
|
|
QADD05
|
|
|
->,>>>,>>9.9999
|
10
|
|
|
QADD06
|
|
|
->,>>>,>>9.9999
|
10
|
|
|
QADL01
|
|
|
yes/no
|
|
|
|
QADL02
|
|
|
yes/no
|
|
|
|
QADL03
|
|
|
yes/no
|
|
|
|
QADL04
|
|
|
yes/no
|
|
|
|
QADL05
|
|
|
yes/no
|
|
|
|
QADL06
|
|
|
yes/no
|
|
|
|
QADT01
|
|
|
99/99/9999
|
|
|
|
QADT02
|
|
|
99/99/9999
|
|
|
|
QADT03
|
|
|
99/99/9999
|
|
|
|
QADT04
|
|
|
99/99/9999
|
|
|
|
QADT05
|
|
|
99/99/9999
|
|
|
|
QADT06
|
|
|
99/99/9999
|
|
|
|
RRGLControl_ID
|
Record ID
|
|
-99999999999
|
|
|
|
RRGLControlIsAllCostCentre
|
All Cost Centers
|
|
yes/no
|
|
|
|
RRGLControlIsAllDivision
|
All Sub-Accounts
|
|
yes/no
|
|
|
|
RRGLControlIsAllProject
|
All Projects
|
|
yes/no
|
|
|
|
RRGLControlIsAllSAF
|
All SAFs
|
|
yes/no
|
|
|
|
SalesCostCentre_ID
|
Link To CostCentre (Sales)
|
|
-99999999999
|
|
|
|
SalesDivision_ID
|
Link To Division (Sales)
|
|
-99999999999
|
|
|
|
SalesGL_ID
|
Link To GL (Sales)
|
|
-99999999999
|
|
|
|
SalesProject_ID
|
Link To Project (Sales)
|
|
-99999999999
|
|
|
|
Index-Name
|
Uni
|
Field-Name
|
Asc
|
Abbr
|
|
|
AccruedCC
|
no
|
AccruedCostCentre_ID
|
yes
|
no
|
|
|
AccruedDiv
|
no
|
AccruedDivision_ID
|
yes
|
no
|
|
|
AccruedGL
|
no
|
AccruedGL_ID
|
yes
|
no
|
|
|
AccruedPrj
|
no
|
AccruedProject_ID
|
yes
|
no
|
|
|
CombCyIdx
|
no
|
Company_ID
|
yes
|
no
|
|
|
|
|
SalesGL_ID
|
yes
|
no
|
|
|
|
|
SalesDivision_ID
|
yes
|
no
|
|
|
|
|
SalesCostCentre_ID
|
yes
|
no
|
|
|
|
|
SalesProject_ID
|
yes
|
no
|
|
|
CombDomCompIdx
|
no
|
Domain_ID
|
yes
|
no
|
|
|
|
|
Company_ID
|
yes
|
no
|
|
|
|
|
SalesGL_ID
|
yes
|
no
|
|
|
|
|
SalesDivision_ID
|
yes
|
no
|
|
|
|
|
SalesCostCentre_ID
|
yes
|
no
|
|
|
|
|
SalesProject_ID
|
yes
|
no
|
|
|
CombDomIdx
|
no
|
Domain_ID
|
yes
|
no
|
|
|
|
|
SalesGL_ID
|
yes
|
no
|
|
|
|
|
SalesDivision_ID
|
yes
|
no
|
|
|
|
|
SalesCostCentre_ID
|
yes
|
no
|
|
|
|
|
SalesProject_ID
|
yes
|
no
|
|
|
CyIdx
|
no
|
Company_ID
|
yes
|
no
|
|
|
DeferredCC
|
no
|
DeferredCostCentre_ID
|
yes
|
no
|
|
|
DeferredDiv
|
no
|
DeferredDivision_ID
|
yes
|
no
|
|
|
DeferredGL
|
no
|
DeferredGL_ID
|
yes
|
no
|
|
|
DeferredPrj
|
no
|
DeferredProject_ID
|
yes
|
no
|
|
|
DomainIdx
|
no
|
Domain_ID
|
yes
|
no
|
|
∗
|
Prim
|
yes
|
RRGLControl_ID
|
yes
|
no
|
|
|
SalesCC
|
no
|
SalesCostCentre_ID
|
yes
|
no
|
|
|
SalesDiv
|
no
|
SalesDivision_ID
|
yes
|
no
|
|
|
SalesGL
|
no
|
SalesGL_ID
|
yes
|
no
|
|
|
SalesPrj
|
no
|
SalesProject_ID
|
yes
|
no
|
|
|
Field Name
|
Label
|
Col-Label
|
Format
|
Dec
|
|
|
Company_ID
|
Link to Company
|
|
-99999999999
|
|
|
|
Currency_ID
|
Link to Currency
|
|
-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)
|
|
|
|
Domain_ID
|
Link to Domains
|
|
-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)
|
|
|
|
QADC03
|
|
|
x(40)
|
|
|
|
QADC04
|
|
|
x(40)
|
|
|
|
QADC05
|
|
|
x(40)
|
|
|
|
QADC06
|
|
|
x(40)
|
|
|
|
QADD01
|
|
|
->,>>>,>>9.9999
|
10
|
|
|
QADD02
|
|
|
->,>>>,>>9.9999
|
10
|
|
|
QADD03
|
|
|
->,>>>,>>9.9999
|
10
|
|
|
QADD04
|
|
|
->,>>>,>>9.9999
|
10
|
|
|
QADD05
|
|
|
->,>>>,>>9.9999
|
10
|
|
|
QADD06
|
|
|
->,>>>,>>9.9999
|
10
|
|
|
QADL01
|
|
|
yes/no
|
|
|
|
QADL02
|
|
|
yes/no
|
|
|
|
QADL03
|
|
|
yes/no
|
|
|
|
QADL04
|
|
|
yes/no
|
|
|
|
QADL05
|
|
|
yes/no
|
|
|
|
QADL06
|
|
|
yes/no
|
|
|
|
QADT01
|
|
|
99/99/9999
|
|
|
|
QADT02
|
|
|
99/99/9999
|
|
|
|
QADT03
|
|
|
99/99/9999
|
|
|
|
QADT04
|
|
|
99/99/9999
|
|
|
|
QADT05
|
|
|
99/99/9999
|
|
|
|
QADT06
|
|
|
99/99/9999
|
|
|
|
RRPriceList_ID
|
Record ID
|
|
-99999999999
|
|
|
|
RRPriceListCode
|
Code
|
|
x(20)
|
|
|
|
RRPriceListDesc
|
Description
|
|
x(40)
|
|
|
|
RRPriceListExpireDate
|
Expire Date
|
|
99/99/9999
|
|
|
|
RRPriceListPart
|
Item
|
|
x(18)
|
|
|
|
RRPriceListProdLine
|
Product Line
|
|
x(20)
|
|
|
|
RRPriceListSite
|
Site
|
|
x(8)
|
|
|
|
RRPriceListStartDate
|
Start Date
|
|
99/99/9999
|
|
|
|
RRPriceListUoM
|
Unit of Measure
|
|
x(2)
|
|
|
|
Index-Name
|
Uni
|
Field-Name
|
Asc
|
Abbr
|
|
|
AltIdx
|
no
|
Domain_ID
|
yes
|
no
|
|
|
|
|
Company_ID
|
yes
|
no
|
|
|
|
|
Currency_ID
|
yes
|
no
|
|
|
|
|
RRPriceListSite
|
yes
|
no
|
|
|
|
|
RRPriceListProdLine
|
yes
|
no
|
|
|
|
|
RRPriceListPart
|
yes
|
no
|
|
|
|
|
RRPriceListStartDate
|
yes
|
no
|
|
∗
|
Prim
|
yes
|
RRPriceList_ID
|
yes
|
no
|
|
|
Field Name
|
Label
|
Col-Label
|
Format
|
Dec
|
|
|
CustomCombo0
|
Custom Combo Field
|
|
x(20)
|
|
|
|
CustomCombo1
|
Custom Combo Field
|
|
x(20)
|
|
|
|
CustomCombo2
|
Custom Combo Field
|
|
x(20)
|
|
|
|
CustomCombo3
|
Custom Combo Field
|
|
x(20)
|
|
|
|
CustomCombo4
|
Custom Combo Field
|
|
x(20)
|
|
|
|
CustomCombo5
|
Custom Combo Field
|
|
x(20)
|
|
|
|
CustomCombo6
|
Custom Combo Field
|
|
x(20)
|
|
|
|
CustomCombo7
|
Custom Combo Field
|
|
x(20)
|
|
|
|
CustomCombo8
|
Custom Combo Field
|
|
x(20)
|
|
|
|
CustomCombo9
|
Custom Combo Field
|
|
x(20)
|
|
|
|
CustomDate0
|
Custom Date Field
|
|
99/99/9999
|
|
|
|
CustomDate1
|
Custom Date Field
|
|
99/99/9999
|
|
|
|
CustomDate2
|
Custom Date Field
|
|
99/99/9999
|
|
|
|
CustomDate3
|
Custom Date Field
|
|
99/99/9999
|
|
|
|
CustomDate4
|
Custom Date Field
|
|
99/99/9999
|
|
|
|
CustomDecimal0
|
Custom Decimal Field
|
|
->,>>>,>>9.99
|
4
|
|
|
CustomDecimal1
|
Custom Decimal Field
|
|
->,>>>,>>9.99
|
4
|
|
|
CustomDecimal2
|
Custom Decimal Field
|
|
->,>>>,>>9.99
|
4
|
|
|
CustomDecimal3
|
Custom Decimal Field
|
|
->,>>>,>>9.99
|
4
|
|
|
CustomDecimal4
|
Custom Decimal Field
|
|
->,>>>,>>9.99
|
4
|
|
|
CustomInteger0
|
Custom Integer Field
|
|
->,>>>,>>9
|
|
|
|
CustomInteger1
|
Custom Integer Field
|
|
->,>>>,>>9
|
|
|
|
CustomInteger2
|
Custom Integer Field
|
|
->,>>>,>>9
|
|
|
|
CustomInteger3
|
Custom Integer Field
|
|
->,>>>,>>9
|
|
|
|
CustomInteger4
|
Custom Integer Field
|
|
->,>>>,>>9
|
|
|
|
CustomLong0
|
Custom Long Field
|
|
x(255)
|
|
|
|
CustomLong1
|
Custom Long Field
|
|
x(255)
|
|
|
|
CustomNote
|
Custom Note Field
|
|
x(2000)
|
|
|
|
CustomShort0
|
Custom Short Field
|
|
x(20)
|
|
|
|
CustomShort1
|
Custom Short Field
|
|
x(20)
|
|
|
|
CustomShort2
|
Custom Short Field
|
|
x(20)
|
|
|
|
CustomShort3
|
Custom Short Field
|
|
x(20)
|
|
|
|
CustomShort4
|
Custom Short Field
|
|
x(20)
|
|
|
|
CustomShort5
|
Custom Short Field
|
|
x(20)
|
|
|
|
CustomShort6
|
Custom Short Field
|
|
x(20)
|
|
|
|
CustomShort7
|
Custom Short Field
|
|
x(20)
|
|
|
|
CustomShort8
|
Custom Short Field
|
|
x(20)
|
|
|
|
CustomShort9
|
Custom Short Field
|
|
x(20)
|
|
|
|
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)
|
|
|
|
QADC03
|
|
|
x(40)
|
|
|
|
QADC04
|
|
|
x(40)
|
|
|
|
QADC05
|
|
|
x(40)
|
|
|
|
QADC06
|
|
|
x(40)
|
|
|
|
QADD01
|
|
|
->,>>>,>>9.9999
|
10
|
|
|
QADD02
|
|
|
->,>>>,>>9.9999
|
10
|
|
|
QADD03
|
|
|
->,>>>,>>9.9999
|
10
|
|
|
QADD04
|
|
|
->,>>>,>>9.9999
|
10
|
|
|
QADD05
|
|
|
->,>>>,>>9.9999
|
10
|
|
|
QADD06
|
|
|
->,>>>,>>9.9999
|
10
|
|
|
QADL01
|
|
|
yes/no
|
|
|
|
QADL02
|
|
|
yes/no
|
|
|
|
QADL03
|
|
|
yes/no
|
|
|
|
QADL04
|
|
|
yes/no
|
|
|
|
QADL05
|
|
|
yes/no
|
|
|
|
QADL06
|
|
|
yes/no
|
|
|
|
QADT01
|
|
|
99/99/9999
|
|
|
|
QADT02
|
|
|
99/99/9999
|
|
|
|
QADT03
|
|
|
99/99/9999
|
|
|
|
QADT04
|
|
|
99/99/9999
|
|
|
|
QADT05
|
|
|
99/99/9999
|
|
|
|
QADT06
|
|
|
99/99/9999
|
|
|
|
RRPriceList_ID
|
Link to RRPriceList
|
|
-99999999999
|
|
|
|
RRPriceListLn_ID
|
Record ID
|
|
-99999999999
|
|
|
|
RRPriceListLnHighPRICE
|
Price Upper Limit
|
|
->>>,>>>,>>9.99999
|
10
|
|
|
RRPriceListLnLowPRICE
|
Price Lower Limit
|
|
->>>,>>>,>>9.99999
|
10
|
|
|
RRPriceListLnMinQTY
|
Minimum Qty
|
|
->>>,>>>,>>9.99999
|
10
|
|
|
RRPriceListLnPRICE
|
Price
|
|
->>>,>>>,>>9.99999
|
10
|
|
|
Index-Name
|
Uni
|
Field-Name
|
Asc
|
Abbr
|
|
|
AltIdx
|
yes
|
RRPriceList_ID
|
yes
|
no
|
|
|
|
|
RRPriceListLnMinQTY
|
yes
|
no
|
|
∗
|
Prim
|
yes
|
RRPriceListLn_ID
|
yes
|
no
|
|
|
Field Name
|
Label
|
Col-Label
|
Format
|
Dec
|
|
|
CustomCombo0
|
Custom Combo Field
|
|
x(20)
|
|
|
|
CustomCombo1
|
Custom Combo Field
|
|
x(20)
|
|
|
|
CustomCombo2
|
Custom Combo Field
|
|
x(20)
|
|
|
|
CustomCombo3
|
Custom Combo Field
|
|
x(20)
|
|
|
|
CustomCombo4
|
Custom Combo Field
|
|
x(20)
|
|
|
|
CustomCombo5
|
Custom Combo Field
|
|
x(20)
|
|
|
|
CustomCombo6
|
Custom Combo Field
|
|
x(20)
|
|
|
|
CustomCombo7
|
Custom Combo Field
|
|
x(20)
|
|
|
|
CustomCombo8
|
Custom Combo Field
|
|
x(20)
|
|
|
|
CustomCombo9
|
Custom Combo Field
|
|
x(20)
|
|
|
|
CustomDate0
|
Custom Date Field
|
|
99/99/9999
|
|
|
|
CustomDate1
|
Custom Date Field
|
|
99/99/9999
|
|
|
|
CustomDate2
|
Custom Date Field
|
|
99/99/9999
|
|
|
|
CustomDate3
|
Custom Date Field
|
|
99/99/9999
|
|
|
|
CustomDate4
|
Custom Date Field
|
|
99/99/9999
|
|
|
|
CustomDecimal0
|
Custom Decimal Field
|
|
->,>>>,>>9.99
|
4
|
|
|
CustomDecimal1
|
Custom Decimal Field
|
|
->,>>>,>>9.99
|
4
|
|
|
CustomDecimal2
|
Custom Decimal Field
|
|
->,>>>,>>9.99
|
4
|
|
|
CustomDecimal3
|
Custom Decimal Field
|
|
->,>>>,>>9.99
|
4
|
|
|
CustomDecimal4
|
Custom Decimal Field
|
|
->,>>>,>>9.99
|
4
|
|
|
CustomInteger0
|
Custom Integer Field
|
|
->,>>>,>>9
|
|
|
|
CustomInteger1
|
Custom Integer Field
|
|
->,>>>,>>9
|
|
|
|
CustomInteger2
|
Custom Integer Field
|
|
->,>>>,>>9
|
|
|
|
CustomInteger3
|
Custom Integer Field
|
|
->,>>>,>>9
|
|
|
|
CustomInteger4
|
Custom Integer Field
|
|
->,>>>,>>9
|
|
|
|
CustomLong0
|
Custom Long Field
|
|
x(255)
|
|
|
|
CustomLong1
|
Custom Long Field
|
|
x(255)
|
|
|
|
CustomNote
|
Custom Note Field
|
|
x(2000)
|
|
|
|
CustomShort0
|
Custom Short Field
|
|
x(20)
|
|
|
|
CustomShort1
|
Custom Short Field
|
|
x(20)
|
|
|
|
CustomShort2
|
Custom Short Field
|
|
x(20)
|
|
|
|
CustomShort3
|
Custom Short Field
|
|
x(20)
|
|
|
|
CustomShort4
|
Custom Short Field
|
|
x(20)
|
|
|
|
CustomShort5
|
Custom Short Field
|
|
x(20)
|
|
|
|
CustomShort6
|
Custom Short Field
|
|
x(20)
|
|
|
|
CustomShort7
|
Custom Short Field
|
|
x(20)
|
|
|
|
CustomShort8
|
Custom Short Field
|
|
x(20)
|
|
|
|
CustomShort9
|
Custom Short Field
|
|
x(20)
|
|
|
|
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)
|
|
|
|
QADC03
|
|
|
x(40)
|
|
|
|
QADC04
|
|
|
x(40)
|
|
|
|
QADC05
|
|
|
x(40)
|
|
|
|
QADC06
|
|
|
x(40)
|
|
|
|
QADD01
|
|
|
->,>>>,>>9.9999
|
10
|
|
|
QADD02
|
|
|
->,>>>,>>9.9999
|
10
|
|
|
QADD03
|
|
|
->,>>>,>>9.9999
|
10
|
|
|
QADD04
|
|
|
->,>>>,>>9.9999
|
10
|
|
|
QADD05
|
|
|
->,>>>,>>9.9999
|
10
|
|
|
QADD06
|
|
|
->,>>>,>>9.9999
|
10
|
|
|
QADL01
|
|
|
yes/no
|
|
|
|
QADL02
|
|
|
yes/no
|
|
|
|
QADL03
|
|
|
yes/no
|
|
|
|
QADL04
|
|
|
yes/no
|
|
|
|
QADL05
|
|
|
yes/no
|
|
|
|
QADL06
|
|
|
yes/no
|
|
|
|
QADT01
|
|
|
99/99/9999
|
|
|
|
QADT02
|
|
|
99/99/9999
|
|
|
|
QADT03
|
|
|
99/99/9999
|
|
|
|
QADT04
|
|
|
99/99/9999
|
|
|
|
QADT05
|
|
|
99/99/9999
|
|
|
|
QADT06
|
|
|
99/99/9999
|
|
|
|
RRRule_ID
|
Record ID
|
|
-99999999999
|
|
|
|
RRRuleAcceptParam
|
Acceptance parameter
|
|
x(20)
|
|
|
|
RRRuleCode
|
Revenue Recognition Rule Code
|
|
x(20)
|
|
|
|
RRRuleDaysAfter
|
Additional Number of Days
|
|
>>9
|
|
|
|
RRRuleDescription
|
Description
|
|
x(40)
|
|
|
|
RRRuleIsActive
|
Active
|
|
yes/no
|
|
|
|
RRRuleIsProofOfDel
|
Proof of Delivery
|
|
yes/no
|
|
|
|
RRRuleOccurences
|
Occurences
|
|
>>9
|
|
|
|
RRRulePeriodRecogDateType
|
Recognition Point
|
|
x(20)
|
|
|
|
RRRulePeriodRecogDayOffset
|
Number of Days
|
|
>>9
|
|
|
|
RRRulePeriodType
|
Period Type
|
|
x(20)
|
|
|
|
RRRuleRecognizeAt
|
Revenue Recognized at
|
|
x(20)
|
|
|
|
RRRuleSplitType
|
Split Type
|
|
x(20)
|
|
|
|
RRRuleType
|
Rule Type
|
|
x(20)
|
|
|
|
Index-Name
|
Uni
|
Field-Name
|
Asc
|
Abbr
|
|
|
Code
|
yes
|
RRRuleCode
|
yes
|
no
|
|
|
LastModIdx
|
no
|
LastModifiedDate
|
yes
|
no
|
|
∗
|
Prim
|
yes
|
RRRule_ID
|
yes
|
no
|
|
|
ViewIndex
|
no
|
RRRuleIsActive
|
yes
|
no
|
|
|
|
|
RRRuleCode
|
yes
|
no
|
|
|
Field Name
|
Label
|
Col-Label
|
Format
|
Dec
|
|
|
CustomCombo0
|
|
|
x(20)
|
|
|
|
CustomCombo1
|
|
|
x(20)
|
|
|
|
CustomCombo2
|
|
|
x(20)
|
|
|
|
CustomCombo3
|
|
|
x(20)
|
|
|
|
CustomCombo4
|
|
|
x(20)
|
|
|
|
CustomCombo5
|
|
|
x(20)
|
|
|
|
CustomCombo6
|
|
|
x(20)
|
|
|
|
CustomCombo7
|
|
|
x(20)
|
|
|
|
CustomCombo8
|
|
|
x(20)
|
|
|
|
CustomCombo9
|
|
|
x(20)
|
|
|
|
CustomDate0
|
|
|
99/99/9999
|
|
|
|
CustomDate1
|
|
|
99/99/9999
|
|
|
|
CustomDate2
|
|
|
99/99/9999
|
|
|
|
CustomDate3
|
|
|
99/99/9999
|
|
|
|
CustomDate4
|
|
|
99/99/9999
|
|
|
|
CustomDecimal0
|
|
|
->,>>>,>>9.99
|
4
|
|
|
CustomDecimal1
|
|
|
->,>>>,>>9.99
|
4
|
|
|
CustomDecimal2
|
|
|
->,>>>,>>9.99
|
4
|
|
|
CustomDecimal3
|
|
|
->,>>>,>>9.99
|
4
|
|
|
CustomDecimal4
|
|
|
->,>>>,>>9.99
|
4
|
|
|
CustomInteger0
|
|
|
->,>>>,>>9
|
|
|
|
CustomInteger1
|
|
|
->,>>>,>>9
|
|
|
|
CustomInteger2
|
|
|
->,>>>,>>9
|
|
|
|
CustomInteger3
|
|
|
->,>>>,>>9
|
|
|
|
CustomInteger4
|
|
|
->,>>>,>>9
|
|
|
|
CustomLong0
|
|
|
x(255)
|
|
|
|
CustomLong1
|
|
|
x(255)
|
|
|
|
CustomNote
|
|
|
x(2000)
|
|
|
|
CustomShort0
|
|
|
x(20)
|
|
|
|
CustomShort1
|
|
|
x(20)
|
|
|
|
CustomShort2
|
|
|
x(20)
|
|
|
|
CustomShort3
|
|
|
x(20)
|
|
|
|
CustomShort4
|
|
|
x(20)
|
|
|
|
CustomShort5
|
|
|
x(20)
|
|
|
|
CustomShort6
|
|
|
x(20)
|
|
|
|
CustomShort7
|
|
|
x(20)
|
|
|
|
CustomShort8
|
|
|
x(20)
|
|
|
|
CustomShort9
|
|
|
x(20)
|
|
|
|
Domain_ID
|
Link to Domains
|
|
-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)
|
|
|
|
QADC03
|
|
|
x(40)
|
|
|
|
QADC04
|
|
|
x(40)
|
|
|
|
QADC05
|
|
|
x(40)
|
|
|
|
QADC06
|
|
|
x(40)
|
|
|
|
QADD01
|
|
|
->,>>>,>>9.9999
|
10
|
|
|
QADD02
|
|
|
->,>>>,>>9.9999
|
10
|
|
|
QADD03
|
|
|
->,>>>,>>9.9999
|
10
|
|
|
QADD04
|
|
|
->,>>>,>>9.9999
|
10
|
|
|
QADD05
|
|
|
->,>>>,>>9.9999
|
10
|
|
|
QADD06
|
|
|
->,>>>,>>9.9999
|
10
|
|
|
QADL01
|
|
|
yes/no
|
|
|
|
QADL02
|
|
|
yes/no
|
|
|
|
QADL03
|
|
|
yes/no
|
|
|
|
QADL04
|
|
|
yes/no
|
|
|
|
QADL05
|
|
|
yes/no
|
|
|
|
QADL06
|
|
|
yes/no
|
|
|
|
QADT01
|
|
|
99/99/9999
|
|
|
|
QADT02
|
|
|
99/99/9999
|
|
|
|
QADT03
|
|
|
99/99/9999
|
|
|
|
QADT04
|
|
|
99/99/9999
|
|
|
|
QADT05
|
|
|
99/99/9999
|
|
|
|
QADT06
|
|
|
99/99/9999
|
|
|
|
RRRule_ID
|
Link to Revenue recognition rule
|
|
-99999999999
|
|
|
|
RRRuleDef_ID
|
Record ID
|
|
-99999999999
|
|
|
|
RRRuleDefFromTaxZone
|
From Tax Zone
|
|
x(16)
|
|
|
|
RRRuleDefToTaxZone
|
To Tax Zone
|
|
x(16)
|
|
|
|
Index-Name
|
Uni
|
Field-Name
|
Asc
|
Abbr
|
|
|
DomainIdx
|
no
|
Domain_ID
|
yes
|
no
|
|
∗
|
Prim
|
yes
|
RRRuleDef_ID
|
yes
|
no
|
|
|
RuleIdx
|
no
|
RRRule_ID
|
yes
|
no
|
|
|
UniqueIdx
|
yes
|
Domain_ID
|
yes
|
no
|
|
|
|
|
RRRuleDefFromTaxZone
|
yes
|
no
|
|
|
|
|
RRRuleDefToTaxZone
|
yes
|
no
|
|
|
Field Name
|
Label
|
Col-Label
|
Format
|
Dec
|
|
|
Company_ID
|
Link to Company
|
|
-99999999999
|
|
|
|
Currency_ID
|
Link to Currency
|
|
-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)
|
|
|
|
DebtorType_ID
|
Link to DebtorType
|
|
-99999999999
|
|
|
|
Domain_ID
|
Link to Domains
|
|
-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)
|
|
|
|
QADC03
|
|
|
x(40)
|
|
|
|
QADC04
|
|
|
x(40)
|
|
|
|
QADC05
|
|
|
x(40)
|
|
|
|
QADC06
|
|
|
x(40)
|
|
|
|
QADD01
|
|
|
->,>>>,>>9.9999
|
10
|
|
|
QADD02
|
|
|
->,>>>,>>9.9999
|
10
|
|
|
QADD03
|
|
|
->,>>>,>>9.9999
|
10
|
|
|
QADD04
|
|
|
->,>>>,>>9.9999
|
10
|
|
|
QADD05
|
|
|
->,>>>,>>9.9999
|
10
|
|
|
QADD06
|
|
|
->,>>>,>>9.9999
|
10
|
|
|
QADL01
|
|
|
yes/no
|
|
|
|
QADL02
|
|
|
yes/no
|
|
|
|
QADL03
|
|
|
yes/no
|
|
|
|
QADL04
|
|
|
yes/no
|
|
|
|
QADL05
|
|
|
yes/no
|
|
|
|
QADL06
|
|
|
yes/no
|
|
|
|
QADT01
|
|
|
99/99/9999
|
|
|
|
QADT02
|
|
|
99/99/9999
|
|
|
|
QADT03
|
|
|
99/99/9999
|
|
|
|
QADT04
|
|
|
99/99/9999
|
|
|
|
QADT05
|
|
|
99/99/9999
|
|
|
|
QADT06
|
|
|
99/99/9999
|
|
|
|
RRTemplate_ID
|
Record ID
|
|
-99999999999
|
|
|
|
RRTemplateChannel
|
Channel
|
|
x(8)
|
|
|
|
RRTemplateDesc
|
Template Description
|
|
x(40)
|
|
|
|
RRTemplateItem
|
Item Number
|
|
x(18)
|
|
|
|
RRTemplateMinQTY
|
Min Qty
|
|
->>>,>>>,>>9.99999
|
10
|
|
|
RRTemplateRegion
|
Region
|
|
x(4)
|
|
|
|
RRTemplateUoM
|
Unit of Measure
|
|
x(2)
|
|
|
|
Index-Name
|
Uni
|
Field-Name
|
Asc
|
Abbr
|
|
|
AltIdx
|
yes
|
Domain_ID
|
yes
|
no
|
|
|
|
|
Company_ID
|
yes
|
no
|
|
|
|
|
DebtorType_ID
|
yes
|
no
|
|
|
|
|
Currency_ID
|
yes
|
no
|
|
|
|
|
RRTemplateChannel
|
yes
|
no
|
|
|
|
|
RRTemplateRegion
|
yes
|
no
|
|
|
|
|
RRTemplateItem
|
yes
|
no
|
|
∗
|
Prim
|
yes
|
RRTemplate_ID
|
yes
|
no
|
|
|
Field Name
|
Label
|
Col-Label
|
Format
|
Dec
|
|
|
CustomCombo0
|
Custom Combo Field
|
|
x(20)
|
|
|
|
CustomCombo1
|
Custom Combo Field
|
|
x(20)
|
|
|
|
CustomCombo2
|
Custom Combo Field
|
|
x(20)
|
|
|
|
CustomCombo3
|
Custom Combo Field
|
|
x(20)
|
|
|
|
CustomCombo4
|
Custom Combo Field
|
|
x(20)
|
|
|
|
CustomCombo5
|
Custom Combo Field
|
|
x(20)
|
|
|
|
CustomCombo6
|
Custom Combo Field
|
|
x(20)
|
|
|
|
CustomCombo7
|
Custom Combo Field
|
|
x(20)
|
|
|
|
CustomCombo8
|
Custom Combo Field
|
|
x(20)
|
|
|
|
CustomCombo9
|
Custom Combo Field
|
|
x(20)
|
|
|
|
CustomDate0
|
Custom Date Field
|
|
99/99/9999
|
|
|
|
CustomDate1
|
Custom Date Field
|
|
99/99/9999
|
|
|
|
CustomDate2
|
Custom Date Field
|
|
99/99/9999
|
|
|
|
CustomDate3
|
Custom Date Field
|
|
99/99/9999
|
|
|
|
CustomDate4
|
Custom Date Field
|
|
99/99/9999
|
|
|
|
CustomDecimal0
|
Custom Decimal Field
|
|
->,>>>,>>9.99
|
4
|
|
|
CustomDecimal1
|
Custom Decimal Field
|
|
->,>>>,>>9.99
|
4
|
|
|
CustomDecimal2
|
Custom Decimal Field
|
|
->,>>>,>>9.99
|
4
|
|
|
CustomDecimal3
|
Custom Decimal Field
|
|
->,>>>,>>9.99
|
4
|
|
|
CustomDecimal4
|
Custom Decimal Field
|
|
->,>>>,>>9.99
|
4
|
|
|
CustomInteger0
|
Custom Integer Field
|
|
->,>>>,>>9
|
|
|
|
CustomInteger1
|
Custom Integer Field
|
|
->,>>>,>>9
|
|
|
|
CustomInteger2
|
Custom Integer Field
|
|
->,>>>,>>9
|
|
|
|
CustomInteger3
|
Custom Integer Field
|
|
->,>>>,>>9
|
|
|
|
CustomInteger4
|
Custom Integer Field
|
|
->,>>>,>>9
|
|
|
|
CustomLong0
|
Custom Long Field
|
|
x(255)
|
|
|
|
CustomLong1
|
Custom Long Field
|
|
x(255)
|
|
|
|
CustomNote
|
Custom Note Field
|
|
x(2000)
|
|
|
|
CustomShort0
|
Custom Short Field
|
|
x(20)
|
|
|
|
CustomShort1
|
Custom Short Field
|
|
x(20)
|
|
|
|
CustomShort2
|
Custom Short Field
|
|
x(20)
|
|
|
|
CustomShort3
|
Custom Short Field
|
|
x(20)
|
|
|
|
CustomShort4
|
Custom Short Field
|
|
x(20)
|
|
|
|
CustomShort5
|
Custom Short Field
|
|
x(20)
|
|
|
|
CustomShort6
|
Custom Short Field
|
|
x(20)
|
|
|
|
CustomShort7
|
Custom Short Field
|
|
x(20)
|
|
|
|
CustomShort8
|
Custom Short Field
|
|
x(20)
|
|
|
|
CustomShort9
|
Custom Short Field
|
|
x(20)
|
|
|
|
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)
|
|
|
|
QADC03
|
|
|
x(40)
|
|
|
|
QADC04
|
|
|
x(40)
|
|
|
|
QADC05
|
|
|
x(40)
|
|
|
|
QADC06
|
|
|
x(40)
|
|
|
|
QADD01
|
|
|
->,>>>,>>9.9999
|
10
|
|
|
QADD02
|
|
|
->,>>>,>>9.9999
|
10
|
|
|
QADD03
|
|
|
->,>>>,>>9.9999
|
10
|
|
|
QADD04
|
|
|
->,>>>,>>9.9999
|
10
|
|
|
QADD05
|
|
|
->,>>>,>>9.9999
|
10
|
|
|
QADD06
|
|
|
->,>>>,>>9.9999
|
10
|
|
|
QADL01
|
|
|
yes/no
|
|
|
|
QADL02
|
|
|
yes/no
|
|
|
|
QADL03
|
|
|
yes/no
|
|
|
|
QADL04
|
|
|
yes/no
|
|
|
|
QADL05
|
|
|
yes/no
|
|
|
|
QADL06
|
|
|
yes/no
|
|
|
|
QADT01
|
|
|
99/99/9999
|
|
|
|
QADT02
|
|
|
99/99/9999
|
|
|
|
QADT03
|
|
|
99/99/9999
|
|
|
|
QADT04
|
|
|
99/99/9999
|
|
|
|
QADT05
|
|
|
99/99/9999
|
|
|
|
QADT06
|
|
|
99/99/9999
|
|
|
|
RRRule_ID
|
Link to RRRule
|
|
-99999999999
|
|
|
|
RRTemplate_ID
|
Link to RRTemplate
|
|
-99999999999
|
|
|
|
RRTemplateLine_ID
|
Record ID
|
|
-99999999999
|
|
|
|
RRTemplateLineIsLinked
|
Linked to Original Document
|
|
yes/no
|
|
|
|
RRTemplateLineIsSeparateObl
|
Separate Perf Obligation
|
|
yes/no
|
|
|
|
RRTemplateLineItem
|
Item
|
|
x(18)
|
|
|
|
RRTemplateLineItemDesc
|
Description
|
|
x(40)
|
|
|
|
RRTemplateLineQTY
|
Qty
|
|
->>>,>>>,>>9.99999
|
10
|
|
|
RRTemplateLineUoM
|
Unit of Measure
|
|
x(2)
|
|
|
|
Index-Name
|
Uni
|
Field-Name
|
Asc
|
Abbr
|
|
∗
|
Prim
|
yes
|
RRTemplateLine_ID
|
yes
|
no
|
|
|
Field Name
|
Label
|
Col-Label
|
Format
|
Dec
|
|
|
oid_rsc_ctrl
|
|
|
>>>>>>>>>>>>>>>>>>>>>>>>>>>9.9<<<<<<<<<
|
10
|
|
|
rsc__qadc01
|
QAD Field
|
|
x(8)
|
|
|
|
rsc__qadc02
|
QAD Field
|
|
x(8)
|
|
|
|
rsc__qadd01
|
QAD Field
|
|
->,>>>,>>9.9<<<<<<<<
|
10
|
|
|
rsc__qadd02
|
QAD Field
|
|
->,>>>,>>9.9<<<<<<<<
|
10
|
|
|
rsc__qadi01
|
QAD Field
|
|
->,>>>,>>9
|
|
|
|
rsc__qadi02
|
QAD Field
|
|
->,>>>,>>9
|
|
|
|
rsc__qadi03
|
|
|
->>>>>>>9
|
|
|
|
rsc__qadl01
|
QAD Field
|
|
yes/no
|
|
|
|
rsc__qadl02
|
QAD Field
|
|
yes/no
|
|
|
|
rsc__qadl03
|
QAD Field
|
|
yes/no
|
|
|
|
rsc__qadl04
|
QAD Field
|
|
yes/no
|
|
|
|
rsc__qadt01
|
QAD Field
|
|
99/99/99
|
|
|
|
rsc_active
|
Enable Shipping Schedule
|
|
yes/no
|
|
|
|
rsc_auto_update
|
Auto Update Plan From Ship
|
|
yes/no
|
|
|
|
rsc_domain
|
Domain
|
|
x(8)
|
|
|
|
rsc_fab_days
|
Fab Auth Days
|
|
>>9
|
|
|
|
rsc_firm_days
|
Firm Days
|
|
>>9
|
|
|
|
rsc_gen_ship
|
Generate Ship Sched From MRP
|
|
yes/no
|
|
|
|
rsc_raw_days
|
Raw Auth Days
|
|
>>9
|
|
|
|
rsc_ship_days
|
Schedule Days
|
|
>>9
|
|
|
|
rsc_ship_months
|
Schedule Months
|
|
>>9
|
|
|
|
rsc_ship_weeks
|
Schedule Weeks
|
|
>>9
|
|
|
|
rsc_user1
|
Ufld1
|
|
x(8)
|
|
|
|
rsc_user2
|
Ufld2
|
|
x(8)
|
|
|
|
rsc_zero_req
|
Send Zero Requirements
|
|
yes/no
|
|
|
|
Index-Name
|
Uni
|
Field-Name
|
Asc
|
Abbr
|
|
|
oid_rsc_ctrl
|
yes
|
oid_rsc_ctrl
|
yes
|
no
|
|
∗
|
rsc_index1
|
yes
|
rsc_domain
|
yes
|
no
|
|
|
Field Name
|
Label
|
Col-Label
|
Format
|
Dec
|
|
|
oid_rsd_det
|
|
|
>>>>>>>>>>>>>>>>>>>>>>>>>>>9.9<<<<<<<<<
|
10
|
|
|
rsd__qadc01
|
|
|
x(8)
|
|
|
|
rsd_cap
|
Cap/Day
|
|
->>>,>>9.9
|
10
|
|
|
rsd_domain
|
Domain
|
|
x(8)
|
|
|
|
rsd_end
|
End Date
|
|
99/99/99
|
|
|
|
rsd_ref
|
Reference
|
|
x(8)
|
|
|
|
rsd_rsc
|
Resource
|
|
x(8)
|
|
|
|
rsd_shift1
|
Shift1
|
|
->>,>>9.99
|
10
|
|
|
rsd_shift2
|
Shift2
|
|
->>,>>9.99
|
10
|
|
|
rsd_shift3
|
Shift3
|
|
->>,>>9.99
|
10
|
|
|
rsd_shift4
|
Shift4
|
|
->>,>>9.99
|
10
|
|
|
rsd_site
|
Site
|
|
x(8)
|
|
|
|
rsd_start
|
Start Date
|
Start
|
99/99/99
|
|
|
|
rsd_user1
|
Ufld1
|
|
x(8)
|
|
|
|
rsd_user2
|
Ufld2
|
|
x(8)
|
|
|
|
Index-Name
|
Uni
|
Field-Name
|
Asc
|
Abbr
|
|
|
oid_rsd_det
|
yes
|
oid_rsd_det
|
yes
|
no
|
|
∗
|
rsd_rsc
|
yes
|
rsd_domain
|
yes
|
no
|
|
|
|
|
rsd_rsc
|
yes
|
no
|
|
|
|
|
rsd_site
|
yes
|
no
|
|
|
|
|
rsd_ref
|
yes
|
no
|
|
|
rsd_site
|
yes
|
rsd_domain
|
yes
|
no
|
|
|
|
|
rsd_site
|
yes
|
no
|
|
|
|
|
rsd_rsc
|
yes
|
no
|
|
|
|
|
rsd_ref
|
yes
|
no
|
|
|
Field Name
|
Label
|
Col-Label
|
Format
|
Dec
|
|
|
oid_rsn_ref
|
|
|
>>>>>>>>>>>>>>>>>>>>>>>>>>>9.9<<<<<<<<<
|
10
|
|
|
rsn__qadc01
|
|
|
x(8)
|
|
|
|
rsn_code
|
Reason Code
|
Code
|
x(8)
|
|
|
|
rsn_desc
|
Description
|
|
x(24)
|
|
|
|
rsn_domain
|
Domain
|
|
x(8)
|
|
|
|
rsn_mod_date
|
Modified Date
|
Mod Date
|
99/99/99
|
|
|
|
rsn_mod_userid
|
User ID
|
|
x(8)
|
|
|
|
rsn_type
|
Reason Type
|
Type
|
x(8)
|
|
|
|
rsn_user1
|
Ufld1
|
|
x(8)
|
|
|
|
rsn_user2
|
Ufld2
|
|
x(8)
|
|
|
|
Index-Name
|
Uni
|
Field-Name
|
Asc
|
Abbr
|
|
|
oid_rsn_ref
|
yes
|
oid_rsn_ref
|
yes
|
no
|
|
∗
|
rsn_code
|
yes
|
rsn_domain
|
yes
|
no
|
|
|
|
|
rsn_code
|
yes
|
no
|
|
|
|
|
rsn_type
|
yes
|
no
|
|
|
rsn_type
|
yes
|
rsn_domain
|
yes
|
no
|
|
|
|
|
rsn_type
|
yes
|
no
|
|
|
|
|
rsn_code
|
yes
|
no
|
|
|
Field Name
|
Label
|
Col-Label
|
Format
|
Dec
|
|
|
oid_rstd_det
|
|
|
>>>>>>>>>>>>>>>>>>>>>>>>>>>9.9<<<<<<<<<
|
10
|
|
|
rstd__qadc01
|
|
|
x(8)
|
|
|
|
rstd_appr_code
|
Routing Slip
|
|
x(8)
|
|
|
|
rstd_canreroute
|
Can Re-Route
|
|
yes/no
|
|
|
|
rstd_domain
|
Domain
|
|
x(8)
|
|
|
|
rstd_group
|
Group
|
|
x(8)
|
|
|
|
rstd_mod_date
|
Modified Date
|
Mod Date
|
99/99/99
|
|
|
|
rstd_notify_nxt
|
Notify When Next
|
Nxt
|
yes/no
|
|
|
|
rstd_sequence
|
Sequence
|
Seq
|
>>9
|
|
|
|
rstd_svrty_lvl
|
Severity Level
|
|
>>9
|
|
|
|
rstd_user1
|
Ufld1
|
|
x(8)
|
|
|
|
rstd_user2
|
Ufld2
|
|
x(8)
|
|
|
|
rstd_userid
|
User ID
|
|
x(8)
|
|
|
|
Index-Name
|
Uni
|
Field-Name
|
Asc
|
Abbr
|
|
|
oid_rstd_det
|
yes
|
oid_rstd_det
|
yes
|
no
|
|
∗
|
rstd_codegroup
|
yes
|
rstd_domain
|
yes
|
no
|
|
|
|
|
rstd_appr_code
|
yes
|
no
|
|
|
|
|
rstd_group
|
yes
|
no
|
|
|
Field Name
|
Label
|
Col-Label
|
Format
|
Dec
|
|
|
oid_rst_mstr
|
|
|
>>>>>>>>>>>>>>>>>>>>>>>>>>>9.9<<<<<<<<<
|
10
|
|
|
rst__qadc01
|
|
|
x(8)
|
|
|
|
rst_appr_code
|
Routing Slip
|
|
x(8)
|
|
|
|
rst_desc
|
Description
|
|
X(24)
|
|
|
|
rst_domain
|
Domain
|
|
x(8)
|
|
|
|
rst_mod_date
|
Modified Date
|
Mod Date
|
99/99/99
|
|
|
|
rst_notify1
|
Notification List 1
|
|
X(72)
|
|
|
|
rst_notify1_mail
|
E-mail List 1
|
|
X(255)
|
|
|
|
rst_notify2
|
Notification List 2
|
|
X(72)
|
|
|
|
rst_notify2_mail
|
E-mail List 2
|
|
X(255)
|
|
|
|
rst_svrty_list
|
Severity List
|
Severity
|
x(8)
|
|
|
|
rst_user1
|
Ufld1
|
|
x(8)
|
|
|
|
rst_user2
|
Ufld2
|
|
x(8)
|
|
|
|
rst_userid
|
User ID
|
|
x(8)
|
|
|
|
Index-Name
|
Uni
|
Field-Name
|
Asc
|
Abbr
|
|
|
oid_rst_mstr
|
yes
|
oid_rst_mstr
|
yes
|
no
|
|
∗
|
rst_code
|
yes
|
rst_domain
|
yes
|
no
|
|
|
|
|
rst_appr_code
|
yes
|
no
|
|
|
Field Name
|
Label
|
Col-Label
|
Format
|
Dec
|
|
|
oid_rsud_det
|
|
|
>>>>>>>>>>>>>>>>>>>>>>>>>>>9.9<<<<<<<<<
|
10
|
|
|
rsud__qadc01
|
|
|
x(8)
|
|
|
|
rsud_appr_date
|
Date Approved
|
AppDate
|
99/99/99
|
|
|
|
rsud_approved
|
Approved
|
Appr
|
yes/no
|
|
|
|
rsud_approverid
|
Approver ID
|
ID
|
X(8)
|
|
|
|
rsud_canreroute
|
Can Re-Route
|
ReRoute
|
yes/no
|
|
|
|
rsud_cmmtindx
|
Comment Index
|
CmtIndex
|
>>>>>>>>9
|
|
|
|
rsud_domain
|
Domain
|
|
x(8)
|
|
|
|
rsud_group
|
Group
|
|
X(8)
|
|
|
|
rsud_index
|
Index
|
|
>>>>>>>>9
|
|
|
|
rsud_notify_nxt
|
Notify When Next
|
Nxt
|
yes/no
|
|
|
|
rsud_reroute_date
|
Reroute Date
|
|
99/99/99
|
|
|
|
rsud_sequence
|
Sequence
|
Seq
|
>>9
|
|
|
|
rsud_svrty_lvl
|
Severity Level
|
|
>>9
|
|
|
|
rsud_user1
|
Ufld1
|
|
X(8)
|
|
|
|
rsud_user2
|
Ufld2
|
|
X(8)
|
|
|
|
Index-Name
|
Uni
|
Field-Name
|
Asc
|
Abbr
|
|
|
oid_rsud_det
|
yes
|
oid_rsud_det
|
yes
|
no
|
|
∗
|
rsud_indexgroup
|
yes
|
rsud_domain
|
yes
|
no
|
|
|
|
|
rsud_index
|
yes
|
no
|
|
|
|
|
rsud_group
|
yes
|
no
|
|
|
rsud_sequence
|
no
|
rsud_domain
|
yes
|
no
|
|
|
|
|
rsud_index
|
yes
|
no
|
|
|
|
|
rsud_sequence
|
yes
|
no
|
|
|
Field Name
|
Label
|
Col-Label
|
Format
|
Dec
|
|
|
oid_rsu_mstr
|
|
|
>>>>>>>>>>>>>>>>>>>>>>>>>>>9.9<<<<<<<<<
|
10
|
|
|
rsu__qadc01
|
|
|
x(8)
|
|
|
|
rsu_appr_code
|
Approval Code
|
Code
|
X(8)
|
|
|
|
rsu_appr_date
|
Approved Date
|
ApprDate
|
99/99/99
|
|
|
|
rsu_doc_nbr
|
Document Number
|
DocNbr
|
X(40)
|
0
|
|
|
rsu_doc_type
|
Document Type
|
Doc Type
|
X(8)
|
0
|
|
|
rsu_domain
|
Domain
|
|
x(8)
|
|
|
|
rsu_index
|
Index
|
|
>>>>>>>>9
|
|
|
|
rsu_notify2
|
Notification List 2
|
NotifyLst2
|
X(72)
|
|
|
|
rsu_notify2_mail
|
E-mail List 2
|
|
X(255)
|
|
|
|
rsu_route_date
|
Routed Date
|
RouteDate
|
99/99/99
|
|
|
|
rsu_user1
|
Ufld1
|
|
X(8)
|
|
|
|
rsu_user2
|
Ufld2
|
|
X(8)
|
|
|
|
Index-Name
|
Uni
|
Field-Name
|
Asc
|
Abbr
|
|
|
oid_rsu_mstr
|
yes
|
oid_rsu_mstr
|
yes
|
no
|
|
|
rsu_doc_nbr
|
no
|
rsu_domain
|
yes
|
no
|
|
|
|
|
rsu_doc_nbr
|
yes
|
no
|
|
|
|
|
rsu_doc_type
|
yes
|
no
|
|
∗
|
rsu_index
|
yes
|
rsu_domain
|
yes
|
no
|
|
|
|
|
rsu_index
|
yes
|
no
|
|
|
Field Name
|
Label
|
Col-Label
|
Format
|
Dec
|
|
|
oid_rs_mstr
|
|
|
>>>>>>>>>>>>>>>>>>>>>>>>>>>9.9<<<<<<<<<
|
10
|
|
|
rs__qadc01
|
|
|
x(8)
|
|
|
|
rs_desc
|
Description
|
|
x(24)
|
|
|
|
rs_domain
|
Domain
|
|
x(8)
|
|
|
|
rs_rsc
|
Resource
|
|
x(8)
|
|
|
|
rs_site
|
Site
|
|
x(8)
|
|
|
|
rs_um
|
UM
|
|
x(2)
|
|
|
|
rs_user1
|
Ufld1
|
|
x(8)
|
|
|
|
rs_user2
|
Ufld2
|
|
x(8)
|
|
|
|
Index-Name
|
Uni
|
Field-Name
|
Asc
|
Abbr
|
|
|
oid_rs_mstr
|
yes
|
oid_rs_mstr
|
yes
|
no
|
|
|
rs_desc
|
yes
|
rs_domain
|
yes
|
no
|
|
|
|
|
rs_desc
|
yes
|
no
|
|
|
|
|
rs_rsc
|
yes
|
no
|
|
|
|
|
rs_site
|
yes
|
no
|
|
∗
|
rs_rsc
|
yes
|
rs_domain
|
yes
|
no
|
|
|
|
|
rs_rsc
|
yes
|
no
|
|
|
|
|
rs_site
|
yes
|
no
|
|
|
Field Name
|
Label
|
Col-Label
|
Format
|
Dec
|
|
|
CreateDate
|
Create Date
|
|
99/99/99
|
|
|
|
CreateUserID
|
Created
|
|
x(8)
|
|
|
|
Description
|
Description
|
|
x(64)
|
|
|
|
Domain
|
Domain
|
|
x(8)
|
|
|
|
ModDate
|
Modified
|
|
99/99/99
|
|
|
|
ModUserID
|
Modified
|
|
x(8)
|
|
|
|
NewProg
|
Custom Program
|
|
x(12)
|
|
|
|
oid_RunD
|
|
|
>>>>>>>>>>>>>>>>>>>>>>>>>>>9.9<<<<<<<<<
|
10
|
|
|
OldProg
|
Mfg/Pro Program
|
|
x(12)
|
|
|
|
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
|
|
|
|
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_RunD
|
yes
|
oid_RunD
|
yes
|
no
|
|
∗
|
OldNew
|
yes
|
Domain
|
yes
|
no
|
|
|
|
|
OldProg
|
yes
|
no
|
|
|
|
|
NewProg
|
yes
|
no
|
|
|
UsrIdx
|
no
|
Domain
|
yes
|
no
|
|
|
|
|
User1
|
yes
|
no
|
|
|
|
|
User2
|
yes
|
no
|
|
|
Field Name
|
Label
|
Col-Label
|
Format
|
Dec
|
|
|
oid_sab_det
|
|
|
>>>>>>>>>>>>>>>>>>>>>>>>>>>9.9<<<<<<<<<
|
10
|
|
|
sab__qadc01
|
|
|
x(24)
|
|
|
|
sab__qadc02
|
|
|
x(24)
|
|
|
|
sab__qadd01
|
|
|
->>>>,>>>,>>9.99<<<<<<<<
|
10
|
|
|
sab__qadi01
|
|
|
->>>>>>>9
|
|
|
|
sab__qadl01
|
|
|
yes/no
|
|
|
|
sab__qadt01
|
|
|
99/99/99
|
|
|
|
sab_amt_type
|
Amount Type
|
AT
|
x(1)
|
|
|
|
sab_bill_to
|
Bill To
|
|
x(8)
|
|
|
|
sab_billed_date
|
Billed Date
|
|
99/99/99
|
|
|
|
sab_billed_time
|
Billed Time
|
|
x(8)
|
|
|
|
sab_curr
|
Currency
|
Cur
|
x(3)
|
|
|
|
sab_cust
|
Customer
|
|
x(8)
|
|
|
|
sab_cycle
|
Billing Cycle
|
Cyc
|
x(2)
|
|
|
|
sab_desc
|
Description
|
|
x(24)
|
|
|
|
sab_domain
|
Domain
|
|
x(8)
|
|
|
|
sab_end_cover
|
End Cover
|
|
99/99/99
|
|
|
|
sab_end_date
|
End Date
|
|
99/99/99
|
|
|
|
sab_eu_nbr
|
End User
|
|
x(8)
|
|
|
|
sab_ex_rate
|
Exch Rate
|
|
>>>>,>>>,>>9.9<<<<<<<<<
|
10
|
|
|
sab_ex_rate2
|
Exch Rate 2
|
|
>>>>,>>>,>>9.9<<<<<<<<<
|
10
|
|
|
sab_ex_ratetype
|
Rate Type
|
|
x(8)
|
|
|
|
sab_exru_seq
|
Sequence
|
|
>>>>>>>>9
|
|
|
|
sab_ext_price
|
Ext Price
|
|
->>>>,>>>,>>9.99<
|
10
|
|
|
sab_for
|
Supported Item
|
Item
|
x(18)
|
|
|
|
sab_line
|
Contract Line
|
Con Line
|
>>>>>>>9
|
|
|
|
sab_line_seq
|
Line Seq
|
|
>>>>>>>9
|
|
|
|
sab_line_type
|
Line Type
|
LT
|
x(1)
|
|
|
|
sab_list_pr
|
List Price
|
|
->>>>,>>>,>>9.99<<<
|
10
|
|
|
sab_lstcover
|
Last Billed
|
Lst Bill
|
99/99/99
|
|
|
|
sab_mod_date
|
Modified Date
|
Mod Date
|
99/99/99
|
|
|
|
sab_mod_userid
|
User ID
|
|
x(8)
|
|
|
|
sab_nbr
|
Contract
|
|
x(8)
|
|
|
|
sab_prefix
|
Pf
|
|
x(1)
|
|
|
|
sab_price
|
Net Price
|
|
>>>>,>>>,>>9.99<<<
|
10
|
|
|
sab_qty_chg
|
Qty To Bill
|
|
->,>>>,>>9.9<<<<<<<<
|
10
|
|
|
sab_qty_per
|
Duration
|
|
->>>9.9<<<
|
10
|
|
|
sab_ref
|
Ref
|
|
>>>>>>>9
|
|
|
|
sab_serial
|
Lot/Serial
|
|
x(18)
|
|
|
|
sab_so_nbr
|
Sales Order
|
SO
|
x(8)
|
|
|
|
sab_sod_line
|
Sales Order Line
|
SO Ln
|
>>9
|
|
|
|
sab_st_cover
|
Coverage
|
|
99/99/99
|
|
|
|
sab_st_date
|
Start Date
|
Start
|
99/99/99
|
|
|
|
sab_sv_code
|
Service Type
|
Svc Type
|
x(8)
|
|
|
|
sab_tax_env
|
Tax Environment
|
Tax Env
|
x(16)
|
|
|
|
sab_tax_in
|
Tax In
|
|
yes/no
|
|
|
|
sab_tax_usage
|
Tax Usage
|
TaxUsage
|
x(8)
|
|
|
|
sab_taxable
|
Taxable
|
Tax
|
yes/no
|
|
|
|
sab_taxc
|
Tax Class
|
TxC
|
x(3)
|
|
|
|
sab_ui_line
|
Line
|
|
>>>>9
|
|
|
|
sab_user1
|
User Field Character 1
|
|
x(24)
|
|
|
|
sab_user2
|
User Field character 2
|
|
x(24)
|
|
|
|
sab_userd01
|
User Field Decimal 1
|
|
->>>>,>>>,>>9.99<<<<<<<<
|
10
|
|
|
sab_useri01
|
User Field Integer 1
|
|
->>>>>>>9
|
|
|
|
sab_userl01
|
User Field Logical 1
|
|
yes/no
|
|
|
|
sab_usert01
|
User Field Date 1
|
|
99/99/99
|
|
|
|
Index-Name
|
Uni
|
Field-Name
|
Asc
|
Abbr
|
|
|
oid_sab_det
|
yes
|
oid_sab_det
|
yes
|
no
|
|
∗
|
sab_nbr
|
yes
|
sab_domain
|
yes
|
no
|
|
|
|
|
sab_nbr
|
yes
|
no
|
|
|
|
|
sab_prefix
|
yes
|
no
|
|
|
|
|
sab_line
|
yes
|
no
|
|
|
|
|
sab_billed_date
|
yes
|
no
|
|
|
|
|
sab_billed_time
|
yes
|
no
|
|
|
sab_so
|
no
|
sab_domain
|
yes
|
no
|
|
|
|
|
sab_so_nbr
|
yes
|
no
|
|
|
|
|
sab_sod_line
|
yes
|
no
|
|
|
|
|
sab_line_seq
|
yes
|
no
|
|
|
Field Name
|
Label
|
Col-Label
|
Format
|
Dec
|
|
|
oid_sac_ctrl
|
|
|
>>>>>>>>>>>>>>>>>>>>>>>>>>>9.9<<<<<<<<<
|
10
|
|
|
sac__chr01
|
|
|
x(8)
|
|
|
|
sac__chr02
|
|
|
x(8)
|
|
|
|
sac__chr03
|
|
|
x(8)
|
|
|
|
sac__chr04
|
|
|
x(8)
|
|
|
|
sac__chr05
|
|
|
x(8)
|
|
|
|
sac__chr06
|
|
|
x(8)
|
|
|
|
sac__chr07
|
|
|
x(8)
|
|
|
|
sac__chr08
|
|
|
x(8)
|
|
|
|
sac__chr09
|
|
|
x(8)
|
|
|
|
sac__chr10
|
|
|
x(8)
|
|
|
|
sac__dec01
|
|
|
->>>,>>>,>>9.99
|
10
|
|
|
sac__dec02
|
|
|
->>>,>>>,>>9.99
|
10
|
|
|
sac__dec03
|
|
|
->>>,>>>,>>9.99
|
10
|
|
|
sac__dte01
|
|
|
99/99/99
|
|
|
|
sac__dte02
|
|
|
99/99/99
|
|
|
|
sac__dte03
|
|
|
99/99/99
|
|
|
|
sac__dte04
|
|
|
99/99/99
|
|
|
|
sac__log01
|
|
|
yes/no
|
|
|
|
sac__log02
|
|
|
yes/no
|
|
|
|
sac__log03
|
|
|
yes/no
|
|
|
|
sac__log04
|
|
|
yes/no
|
|
|
|
sac__log05
|
|
|
yes/no
|
|
|
|
sac__qad01
|
|
|
>>>>>>9
|
|
|
|
sac__qadc01
|
QAD Character Field 1
|
|
X(8)
|
|
|
|
sac__qadc02
|
QAD Character Field 2
|
|
X(8)
|
|
|
|
sac__qadc03
|
QAD Character Field 3
|
|
X(8)
|
|
|
|
sac__qadi01
|
QAD Integer Field 1
|
|
->,>>>,>>9
|
|
|
|
sac__qadi02
|
QAD Integer Field 2
|
|
->,>>>,>>9
|
|
|
|
sac__qadl01
|
QAD Logical Field 1
|
|
yes/no
|
|
|
|
sac__qadl02
|
QAD Logical Field 2
|
|
yes/no
|
|
|
|
sac__qadl03
|
QAD Logical Field 3
|
|
yes/no
|
|
|
|
sac__qadl04
|
QAD Logical Field 4
|
|
yes/no
|
|
|
|
sac_add_chrg
|
Contract Additional Charges
|
|
yes/no
|
|
|
|
sac_auto_sa
|
Automatic Service Contract #
|
|
yes/no
|
|
|
|
sac_bill_enduser
|
Bill End Users
|
|
yes/no
|
|
|
|
sac_bill_summary
|
Bill Summary
|
|
yes/no
|
|
|
|
sac_calls_mrp
|
PM Calls in MRP
|
|
yes/no
|
|
|
|
sac_company
|
Company Address
|
|
x(8)
|
|
|
|
sac_contract_pr
|
Contract Price Lists
|
|
yes/no
|
|
|
|
sac_create_pm
|
Create PM Calls
|
|
yes/no
|
|
|
|
sac_deferred
|
Use Deferred Accounting
|
|
yes/no
|
|
|
|
sac_domain
|
Domain
|
|
x(8)
|
|
|
|
sac_eu_add_chrg
|
End User Additional Charges
|
|
yes/no
|
|
|
|
sac_eu_totals
|
End User Totals
|
|
yes/no
|
|
|
|
sac_ex_ratetype
|
Rate Type
|
|
x(8)
|
|
|
|
sac_fob
|
F.O.B.
|
|
x(20)
|
|
|
|
sac_free_be
|
Begin or End of Contract
|
|
begin/end
|
|
|
|
sac_free_gt
|
On Contracts >
|
|
>>,>>9
|
|
|
|
sac_free_mth
|
No Months Free Coverage
|
|
>>9
|
|
|
|
sac_gen_def
|
Generate Deferred Accounting
|
|
yes/no
|
|
|
|
sac_hcmmts
|
Service Header Comments
|
|
yes/no
|
|
|
|
sac_index1
|
Index
|
|
>>>>>9
|
|
|
|
sac_int_rnd
|
Intermediate Rounding
|
Intermediate!Rounding
|
yes/no
|
|
|
|
sac_item_enduser
|
Item End Users
|
|
yes/no
|
|
|
|
sac_lcmmts
|
Service Line Comments
|
|
yes/no
|
|
|
|
sac_lim_hist
|
Record Limits History
|
|
yes/no
|
|
|
|
sac_limit_copy
|
Renew Limits From
|
|
X(1)
|
|
|
|
sac_limits_wnd
|
Contract Limits
|
|
yes/no
|
|
|
|
sac_ln_fmt
|
Ln Format S/M
|
|
single/multi
|
|
|
|
sac_mod_date
|
Modified Date
|
Mod Date
|
99/99/99
|
|
|
|
sac_mod_userid
|
User ID
|
|
X(8)
|
|
|
|
sac_pm_days
|
PM Days Scheduling
|
|
yes/no
|
|
|
|
sac_print
|
Are Service Contracts Printed
|
|
yes/no
|
|
|
|
sac_pt_isb
|
Items in Installed Base
|
IB
|
yes/no
|
|
|
|
sac_qo
|
Next Service Quote
|
Nxt Qte
|
>>>>>>>9
|
|
|
|
sac_qo_pre
|
Quote Prefix
|
Qte
|
x(1)
|
|
|
|
sac_renew_fmt
|
Renew Format
|
|
x(4)
|
|
|
|
sac_renewal_days
|
Renewal Days
|
|
->,>>>,>>9
|
|
|
|
sac_reval_bill
|
Revaluate at Billing
|
|
yes/no
|
|
|
|
sac_reval_wnd
|
Revaluation Window
|
|
yes/no
|
|
|
|
sac_revenue
|
Revenue Type
|
|
x(1)
|
|
|
|
sac_rvidx_nxtbl
|
Index at Next Bill
|
|
yes/no
|
|
|
|
sac_sa
|
Next Service Contract
|
|
>>>>>>>9
|
|
|
|
sac_sa_multi
|
Multiple Contracts
|
|
yes/no
|
|
|
|
sac_sa_pre
|
Contract Prefix
|
Ct
|
x(1)
|
|
|
|
sac_sa_site
|
Contract Site
|
|
x(8)
|
|
|
|
sac_saqo_nbr
|
Same Number for Quote/Contract
|
|
yes/no
|
|
|
|
sac_so_hist
|
Keep Contract History
|
|
yes/no
|
|
|
|
sac_so_nbr
|
Next Service Sales order
|
|
>>>>>>>9
|
|
|
|
sac_so_pre
|
Service SO Prefix
|
|
x(3)
|
|
|
|
sac_trl_ntax[3]
|
Nontaxable Trailer Code
|
|
x(2)
|
|
|
|
sac_trl_tax[3]
|
Taxable Trailer Code
|
Trl
|
x(2)
|
|
|
|
sac_user_pricing
|
User Contract Pricing
|
|
yes/no
|
|
|
|
sac_user1
|
Ufld1
|
|
x(8)
|
|
|
|
sac_user2
|
Ufld2
|
|
x(8)
|
|
|
|
Index-Name
|
Uni
|
Field-Name
|
Asc
|
Abbr
|
|
|
oid_sac_ctrl
|
yes
|
oid_sac_ctrl
|
yes
|
no
|
|
∗
|
sac_index1
|
yes
|
sac_domain
|
yes
|
no
|
|
|
Field Name
|
Label
|
Col-Label
|
Format
|
Dec
|
|
|
oid_sadh_hist
|
|
|
>>>>>>>>>>>>>>>>>>>>>>>>>>>9.9<<<<<<<<<
|
10
|
|
|
sadh__chr01
|
User Field #1
|
|
x(8)
|
|
|
|
sadh__chr02
|
User Field #2
|
|
x(8)
|
|
|
|
sadh__chr03
|
User Field #3
|
|
x(8)
|
|
|
|
sadh__chr04
|
User Field #4
|
|
x(8)
|
|
|
|
sadh__chr05
|
User Field #5
|
|
x(8)
|
|
|
|
sadh__chr06
|
User Field #6
|
|
x(8)
|
|
|
|
sadh__chr07
|
User Field #7
|
|
x(8)
|
|
|
|
sadh__chr08
|
User Field #8
|
|
x(8)
|
|
|
|
sadh__chr09
|
User Field #9
|
|
x(8)
|
|
|
|
sadh__chr10
|
User Field #10
|
|
x(8)
|
|
|
|
sadh__dec01
|
User Decimal Field #1
|
|
>>>,>>>,>>9.99
|
10
|
|
|
sadh__dec02
|
User Decimal Field #2
|
|
>>>,>>>,>>9.99
|
10
|
|
|
sadh__dec03
|
User Decimal #3
|
|
->>>,>>>,>>9.99<<<<
|
10
|
|
|
sadh__dte01
|
User Date Field #1
|
|
99/99/99
|
|
|
|
sadh__dte02
|
User Date Field #2
|
|
99/99/99
|
|
|
|
sadh__dte03
|
User Date #3
|
|
99/99/99
|
|
|
|
sadh__log01
|
User Logical #1
|
|
yes/no
|
|
|
|
sadh__log02
|
User Logical #2
|
|
yes/no
|
|
|
|
sadh__log03
|
User Logical #3
|
|
yes/no
|
|
|
|
sadh__qadc01
|
Qad Field #1
|
|
x(8)
|
|
|
|
sadh__qadc02
|
Qad Field #2
|
|
x(8)
|
|
|
|
sadh__qadc03
|
Qad Field #3
|
|
x(8)
|
|
|
|
sadh__qadc04
|
Qad Field #4
|
|
x(8)
|
|
|
|
sadh__qadc05
|
|
|
x(8)
|
|
|
|
sadh__qadc06
|
|
|
x(4)
|
|
|
|
sadh__qadc07
|
|
|
x(8)
|
|
|
|
sadh__qadc08
|
|
|
x(4)
|
|
|
|
sadh__qadc09
|
|
|
x(8)
|
|
|
|
sadh__qadc10
|
|
|
x(4)
|
|
|
|
sadh__qadd01
|
Qad Decimal #1
|
|
->>>,>>>,>>9.99<<<<
|
10
|
|
|
sadh__qadd02
|
Qad Decimal #2
|
|
->>>,>>>,>>9.99<<<<
|
10
|
|
|
sadh__qadd03
|
Qad Decimal #3
|
|
->>>,>>>,>>9.99<<<<
|
10
|
|
|
sadh__qadl01
|
QAD Logical Field
|
|
yes/no
|
|
|
|
sadh__qadl02
|
Qad Logical #2
|
|
yes/no
|
|
|
|
sadh__qadl03
|
Qad Logical #3
|
|
yes/no
|
|
|
|
sadh__qadt01
|
Qad Date #1
|
|
99/99/99
|
|
|
|
sadh__qadt02
|
Qad Date #2
|
|
99/99/99
|
|
|
|
sadh__qadt03
|
Qad Date #3
|
|
99/99/99
|
|
|
|
sadh_amt_type
|
Amount Type
|
AT
|
x(1)
|
|
|
|
sadh_area
|
Area
|
|
x(8)
|
|
|
|
sadh_ca_nbr
|
Call
|
|
x(8)
|
|
|
|
sadh_cancel
|
Cancel Date
|
|
99/99/99
|
|
|
|
sadh_cmtindx
|
Comment Index
|
Comment
|
>>>>>>>9
|
|
|
|
sadh_comm_pct[4]
|
Commission
|
Comm%
|
>>9.99%
|
10
|
|
|
sadh_comment[5]
|
Comments
|
|
x(40)
|
|
|
|
sadh_crt_int
|
Credit Terms Int
|
CRT Int
|
->>>9.99
|
10
|
|
|
sadh_custpart
|
Customer Item
|
|
x(18)
|
|
|
|
sadh_cycle
|
Billing Cycle
|
Cyc
|
x(2)
|
|
|
|
sadh_desc
|
Description
|
|
x(24)
|
|
|
|
sadh_disc_pct
|
Disc %
|
|
->>9.99%
|
10
|
|
|
sadh_discount
|
Discountable
|
|
yes/no
|
|
|
|
sadh_domain
|
Domain
|
|
x(8)
|
|
|
|
sadh_end_date
|
End Date
|
End
|
99/99/99
|
|
|
|
sadh_es_nbr
|
Escalation
|
|
x(8)
|
|
|
|
sadh_eu_nbr
|
End User
|
|
x(8)
|
|
|
|
sadh_expire
|
Expires
|
|
99/99/99
|
|
|
|
sadh_fix_pr
|
Fixed Price
|
|
yes/no
|
|
|
|
sadh_for
|
Supported Item
|
Item
|
x(18)
|
|
|
|
sadh_fst_list
|
FST on List
|
|
yes/no
|
|
|
|
sadh_lastbill
|
Date Last Billed
|
|
99/99/99
|
|
|
|
sadh_line
|
Line
|
Ln
|
>>9
|
|
|
|
sadh_list_pr
|
List Price
|
Lst Price
|
->>>,>>>,>>9.99<<
|
10
|
|
|
sadh_lst_bill
|
Last Bill
|
|
99/99/99
|
|
|
|
sadh_lstcover
|
Last Billed
|
Lst Bill
|
99/99/99
|
|
|
|
sadh_mod_date
|
Modified Date
|
Mod Date
|
99/99/99
|
|
|
|
sadh_mod_userid
|
User ID
|
|
X(8)
|
|
|
|
sadh_mrp
|
Link Line to MRP
|
|
yes/no
|
|
|
|
sadh_nbr
|
Sales Order
|
Order
|
x(10)
|
|
|
|
sadh_nxt_bill
|
Next Bill
|
|
99/99/99
|
|
|
|
sadh_part
|
Service Type
|
Svc Type
|
x(8)
|
|
|
|
sadh_pct_type
|
Percent Type
|
PT
|
x(1)
|
|
|
|
sadh_per_date
|
Perform Date
|
Perform
|
99/99/99
|
|
|
|
sadh_pr_list
|
Price List
|
Prc Lst
|
x(8)
|
|
|
|
sadh_prefix
|
Pf
|
|
x(2)
|
|
|
|
sadh_price
|
Net Price
|
|
>>>>,>>>,>>9.99<<<
|
10
|
|
|
sadh_pricing_dt
|
Pricing Date
|
Price Dt
|
99/99/99
|
|
|
|
sadh_priority
|
Priority
|
Pri
|
>9
|
|
|
|
sadh_prlist_fnd
|
Price List Found
|
|
yes/no
|
|
|
|
sadh_prodline
|
Product Line
|
Line
|
x(4)
|
|
|
|
sadh_project
|
Project
|
|
x(8)
|
|
|
|
sadh_pst
|
PST Taxable
|
|
yes/no
|
|
|
|
sadh_pvm_bill
|
Bill PM
|
|
yes/no
|
|
|
|
sadh_pvm_bom
|
Bill of Material
|
|
x(18)
|
|
|
|
sadh_pvm_only
|
PM Only
|
|
yes/no
|
|
|
|
sadh_pvm_route
|
Routing
|
|
x(18)
|
|
|
|
sadh_qty_bld
|
Billed Count
|
|
->>>,>>9.9<<<<<
|
10
|
|
|
sadh_qty_chg
|
Qty to Bill
|
|
->,>>>,>>9.9<<<<<<<<
|
10
|
|
|
sadh_qty_item
|
Item Quantity
|
Item Qty
|
>>,>>9.9
|
10
|
|
|
sadh_qty_litm
|
Last Item Qty
|
Last Item
|
->>>9.9<<<
|
10
|
|
|
sadh_qty_lst
|
Qty Last Billed
|
Last Qty
|
->,>>>,>>9.9<<
|
10
|
|
|
sadh_qty_per
|
Duration
|
|
->>>9.9<<<
|
10
|
|
|
sadh_ref
|
Ref
|
|
>>>>>>>9
|
|
|
|
sadh_serial
|
Lot/Serial
|
|
x(18)
|
|
|
|
sadh_site
|
Site
|
|
x(8)
|
|
|
|
sadh_slspsn[4]
|
Salesperson
|
Salespsn
|
X(8)
|
0
|
|
|
sadh_so_line
|
Sales Order Line
|
|
>>9
|
|
|
|
sadh_so_ship
|
From Sales Order
|
|
x(8)
|
|
|
|
sadh_so_shipln
|
From SO Line
|
|
>>9
|
|
|
|
sadh_st_cover
|
Coverage
|
|
99/99/99
|
|
|
|
sadh_st_date
|
Start Date
|
Start
|
99/99/99
|
|
|
|
sadh_status
|
Status
|
|
x(8)
|
|
|
|
sadh_std_cost
|
Cost
|
|
->>>,>>>,>>9.99<<<
|
10
|
|
|
sadh_tax_env
|
Tax Environment
|
Tax Env.
|
x(16)
|
0
|
|
|
sadh_tax_in
|
Tax In
|
|
yes/no
|
|
|
|
sadh_tax_usage
|
Nature of Operation
|
Nature
|
x(8)
|
|
|
|
sadh_taxable
|
Taxable
|
Tax
|
yes/no
|
|
|
|
sadh_taxc
|
Tax Code
|
T
|
x(3)
|
|
|
|
sadh_total_bld
|
Total Billed
|
|
>>>>,>>>,>>9.99<<<
|
10
|
|
|
sadh_total_price
|
Total Price
|
|
>>>>,>>>,>>9.99<<<
|
10
|
|
|
sadh_trnbr
|
Transaction
|
|
>>>>>>>>>>>9
|
|
|
|
sadh_type
|
Ship Type
|
T
|
x(1)
|
|
|
|
sadh_um
|
UM
|
|
x(2)
|
|
|
|
sadh_um_conv
|
UM Conversion
|
UM Conv
|
>>>>9.9999<<<<
|
10
|
|
|
sadh_user1
|
Ufld1
|
|
x(8)
|
|
|
|
sadh_user2
|
Ufld2
|
|
x(8)
|
|
|
|
sadh_visits
|
Visits
|
|
>>9
|
10
|
|
|
Index-Name
|
Uni
|
Field-Name
|
Asc
|
Abbr
|
|
|
oid_sadh_hist
|
yes
|
oid_sadh_hist
|
yes
|
no
|
|
|
sadh_nbrln
|
no
|
sadh_domain
|
yes
|
no
|
|
|
|
|
sadh_nbr
|
yes
|
no
|
|
|
|
|
sadh_prefix
|
yes
|
no
|
|
|
|
|
sadh_line
|
yes
|
no
|
|
|
|
|
sadh_end_date
|
yes
|
no
|
|
|
sadh_serial
|
no
|
sadh_domain
|
yes
|
no
|
|
|
|
|
sadh_serial
|
yes
|
no
|
|
|
|
|
sadh_end_date
|
yes
|
no
|
|
∗
|
sadh_trnbr
|
yes
|
sadh_domain
|
yes
|
no
|
|
|
|
|
sadh_trnbr
|
yes
|
no
|
|
|
Field Name
|
Label
|
Col-Label
|
Format
|
Dec
|
|
|
oid_sad_det
|
|
|
>>>>>>>>>>>>>>>>>>>>>>>>>>>9.9<<<<<<<<<
|
10
|
|
|
sad__chr01
|
|
|
x(8)
|
|
|
|
sad__chr02
|
|
|
x(8)
|
|
|
|
sad__chr03
|
|
|
x(8)
|
|
|
|
sad__chr04
|
|
|
x(8)
|
|
|
|
sad__chr05
|
|
|
x(8)
|
|
|
|
sad__chr06
|
|
|
x(8)
|
|
|
|
sad__chr07
|
|
|
x(8)
|
|
|
|
sad__chr08
|
|
|
x(8)
|
|
|
|
sad__chr09
|
|
|
x(8)
|
|
|
|
sad__chr10
|
|
|
x(8)
|
|
|
|
sad__dec01
|
|
|
>>>,>>>,>>9.99
|
10
|
|
|
sad__dec02
|
|
|
>>>,>>>,>>9.99
|
10
|
|
|
sad__dte01
|
|
|
99/99/99
|
|
|
|
sad__dte02
|
|
|
99/99/99
|
|
|
|
sad__log01
|
|
|
yes/no
|
|
|
|
sad__qadc01
|
Qad Field #1
|
|
x(8)
|
|
|
|
sad__qadc02
|
Qad Field #2
|
|
x(8)
|
|
|
|
sad__qadc03
|
Qad Field #3
|
|
x(8)
|
|
|
|
sad__qadc04
|
Qad Field #4
|
|
x(8)
|
|
|
|
sad__qadc05
|
|
|
x(8)
|
|
|
|
sad__qadc06
|
|
|
x(4)
|
|
|
|
sad__qadd01
|
Qad Decimal #1
|
|
->>>,>>>,>>9.99<<<<
|
10
|
|
|
sad__qadd02
|
Qad Decimal #2
|
|
->>>,>>>,>>9.99<<<<
|
10
|
|
|
sad__qadd03
|
Qad Decimal #3
|
|
->>>,>>>,>>9.99<<<<
|
10
|
|
|
sad__qadl01
|
QAD Logical Field
|
|
yes/no
|
|
|
|
sad__qadl02
|
Qad Logical #2
|
|
yes/no
|
|
|
|
sad__qadl03
|
Qad Logical #3
|
|
yes/no
|
|
|
|
sad__qadt01
|
Qad Date #1
|
|
99/99/99
|
|
|
|
sad__qadt02
|
Qad Date #2
|
|
99/99/99
|
|
|
|
sad__qadt03
|
Qad Date #3
|
|
99/99/99
|
|
|
|
sad_accrued
|
Accrued
|
Accr
|
yes/no
|
|
|
|
sad_acct
|
Sales Acct
|
Sales
|
x(8)
|
|
|
|
sad_amt_type
|
Amount Type
|
AT
|
x(1)
|
|
|
|
sad_area
|
Area
|
|
x(8)
|
|
|
|
sad_autorenew
|
Auto Renew
|
Renew
|
yes/no
|
|
|
|
sad_bill_to
|
Bill To
|
|
x(8)
|
|
|
|
sad_blanket_eu
|
Blanket End User
|
|
yes/no
|
|
|
|
sad_ca_nbr
|
Call
|
|
x(8)
|
|
|
|
sad_cancel
|
Cancel Date
|
|
99/99/99
|
|
|
|
sad_cc
|
Cost Ctr
|
CC
|
x(4)
|
|
|
|
sad_cmtindx
|
Comment Index
|
Comment
|
>>>>>>>9
|
|
|
|
sad_comm_pct[4]
|
Commission
|
Comm%
|
>>9.99%
|
10
|
|
|
sad_comment[5]
|
Comments
|
|
x(40)
|
|
|
|
sad_crt_int
|
Credit Terms Int
|
CRT Int
|
->>>9.99
|
10
|
|
|
sad_curr
|
Currency
|
Cur
|
x(3)
|
|
|
|
sad_cust
|
Customer
|
|
x(8)
|
|
|
|
sad_custpart
|
Customer Item
|
|
x(18)
|
|
|
|
sad_cycle
|
Billing Cycle
|
Cyc
|
x(2)
|
|
|
|
sad_desc
|
Description
|
|
x(24)
|
|
|
|
sad_disc_pct
|
Disc %
|
|
->>9.99%
|
10
|
|
|
sad_discount
|
Discountable
|
|
yes/no
|
|
|
|
sad_domain
|
Domain
|
|
x(8)
|
|
|
|
sad_dsc_acct
|
Disc Acct
|
|
x(8)
|
|
|
|
sad_dsc_cc
|
CC
|
|
x(4)
|
|
|
|
sad_dsc_project
|
Disc Project
|
|
x(8)
|
|
|
|
sad_dsc_sub
|
Disc Sub-Acct
|
Sub-Acct
|
x(8)
|
|
|
|
sad_end_date
|
End Date
|
End
|
99/99/99
|
|
|
|
sad_es_nbr
|
Escalation
|
|
x(8)
|
|
|
|
sad_eu_nbr
|
End User
|
|
x(8)
|
|
|
|
sad_ex_rate
|
Exch Rate
|
|
>>>>,>>>,>>9.9<<<<<<<<<
|
10
|
|
|
sad_ex_rate2
|
Exch Rate 2
|
|
>>>>,>>>,>>9.9<<<<<<<<<
|
10
|
|
|
sad_ex_ratetype
|
Rate Type
|
|
x(8)
|
|
|
|
sad_expire
|
Expires
|
|
99/99/99
|
|
|
|
sad_exru_seq
|
Sequence
|
|
>>>>>>>>9
|
|
|
|
sad_fix_pr
|
Fixed Price
|
|
yes/no
|
|
|
|
sad_fix_rate
|
Fixed Rate
|
Fixed
|
yes/no
|
|
|
|
sad_for
|
Supported Item
|
Item
|
x(18)
|
|
|
|
sad_fsrev_acct
|
Revenue Acct
|
Revenue Acct
|
x(8)
|
|
|
|
sad_fsrev_cc
|
Revenue CC
|
CC
|
x(4)
|
|
|
|
sad_fsrev_sub
|
Revenue Sub-Acct
|
Sub-Acct
|
x(8)
|
|
|
|
sad_fst_list
|
FST on List
|
|
yes/no
|
|
|
|
sad_lastbill
|
Date Last Billed
|
|
99/99/99
|
|
|
|
sad_line
|
Contract Line
|
Con Line
|
>>>>>>>9
|
|
|
|
sad_line_type
|
Line Type
|
LT
|
x(1)
|
|
|
|
sad_list_pr
|
List Price
|
Lst Price
|
->>>>,>>>,>>9.99<<<
|
10
|
|
|
sad_lst_bill
|
Last Bill
|
|
99/99/99
|
|
|
|
sad_lstcover
|
Last Billed
|
Lst Bill
|
99/99/99
|
|
|
|
sad_mod_date
|
Modified Date
|
Mod Date
|
99/99/99
|
|
|
|
sad_mod_userid
|
User ID
|
|
X(8)
|
|
|
|
sad_mrp
|
Link Line to MRP
|
|
yes/no
|
|
|
|
sad_nbr
|
Contract
|
|
x(8)
|
|
|
|
sad_nxt_bill
|
Next Bill
|
|
99/99/99
|
|
|
|
sad_parent_line
|
Parent Line
|
|
>>>>>>>9
|
|
|
|
sad_pct_type
|
Percent Type
|
PT
|
x(1)
|
|
|
|
sad_per_date
|
Perform Date
|
Perform
|
99/99/99
|
|
|
|
sad_po
|
Purchase Order
|
|
x(20)
|
|
|
|
sad_pr_list
|
Price List
|
Prc Lst
|
x(8)
|
|
|
|
sad_prefix
|
Pf
|
|
x(2)
|
|
|
|
sad_price
|
Net Price
|
|
>>>>,>>>,>>9.99<<<
|
10
|
|
|
sad_pricing_dt
|
Pricing Date
|
Price Dt
|
99/99/99
|
|
|
|
sad_priority
|
Priority
|
Pri
|
>9
|
|
|
|
sad_prlist_fnd
|
Price List Found
|
|
yes/no
|
|
|
|
sad_prodline
|
Product Line
|
Line
|
x(4)
|
|
|
|
sad_project
|
Project
|
|
x(8)
|
|
|
|
sad_pst
|
PST Taxable
|
|
yes/no
|
|
|
|
sad_pvm_bill
|
Bill PM
|
|
yes/no
|
|
|
|
sad_pvm_bom
|
Bill of Material
|
|
x(18)
|
|
|
|
sad_pvm_only
|
PM Item
|
|
yes/no
|
|
|
|
sad_pvm_route
|
Routing
|
|
x(18)
|
|
|
|
sad_qty_bld
|
Billed Count
|
|
->>>,>>9.9<<<<<
|
10
|
|
|
sad_qty_chg
|
Qty To Bill
|
|
->,>>>,>>9.9<<<<<<<<
|
10
|
|
|
sad_qty_item
|
Item Quantity
|
Item Qty
|
->>,>>9.9
|
10
|
|
|
sad_qty_litm
|
Last Item Qty
|
Last Item
|
->>>9.9<<<
|
10
|
|
|
sad_qty_lst
|
Qty Last Billed
|
Last Qty
|
->,>>>,>>9.9<<
|
10
|
|
|
sad_qty_per
|
Duration
|
|
->>>9.9<<<
|
10
|
|
|
sad_ref
|
Ref
|
|
>>>>>>>9
|
|
|
|
sad_released
|
Released To Contract
|
Rel
|
yes/no
|
|
|
|
sad_renewed_to
|
Renewed To
|
|
x(8)
|
|
|
|
sad_serial
|
Lot/Serial
|
|
x(18)
|
|
|
|
sad_site
|
Site
|
|
x(8)
|
|
|
|
sad_slspsn[4]
|
Salesperson
|
Salespsn
|
X(8)
|
|
|
|
sad_so_nbr
|
Sales Order
|
Order
|
x(8)
|
|
|
|
sad_so_ship
|
From Sales Order
|
|
x(8)
|
|
|
|
sad_so_shipln
|
From SO Line
|
|
>>9
|
|
|
|
sad_sod_line
|
Sales Order Line
|
|
>>9
|
|
|
|
sad_st_cover
|
Coverage
|
|
99/99/99
|
|
|
|
sad_st_date
|
Start Date
|
Start
|
99/99/99
|
|
|
|
sad_status
|
Status
|
|
x(8)
|
|
|
|
sad_std_cost
|
Cost
|
|
->>>,>>>,>>9.99<<<
|
10
|
|
|
sad_sub
|
Sales Sub-Acct
|
Sub-Acct
|
x(8)
|
|
|
|
sad_sv_code
|
Service Type
|
Svc Type
|
x(8)
|
|
|
|
sad_tax_env
|
Tax Environment
|
Tax Env
|
x(16)
|
|
|
|
sad_tax_in
|
Tax In
|
|
yes/no
|
|
|
|
sad_tax_usage
|
Tax Usage
|
TaxUsage
|
x(8)
|
|
|
|
sad_taxable
|
Taxable
|
Tax
|
yes/no
|
|
|
|
sad_taxc
|
Tax Class
|
TxC
|
x(3)
|
|
|
|
sad_total_bld
|
Total Billed
|
|
>>>>,>>>,>>9.99<<<
|
10
|
|
|
sad_type
|
Ship Type
|
T
|
x(1)
|
|
|
|
sad_ui_line
|
Line
|
|
>>>>9
|
|
|
|
sad_um
|
UM
|
|
x(2)
|
|
|
|
sad_um_conv
|
UM Conversion
|
UM Conv
|
>>>>9.9999<<<<
|
10
|
|
|
sad_user1
|
Ufld1
|
|
x(8)
|
|
|
|
sad_user2
|
Ufld2
|
|
x(8)
|
|
|
|
sad_visits
|
Visits
|
|
>>9
|
10
|
|
|
sad_xcomm_pct[2]
|
Commission
|
Comm%
|
>>9.99%
|
10
|
|
|
sad_xslspsn[3]
|
Salesperson
|
Salespsn
|
x(8)
|
0
|
|
|
Index-Name
|
Uni
|
Field-Name
|
Asc
|
Abbr
|
|
|
oid_sad_det
|
yes
|
oid_sad_det
|
yes
|
no
|
|
|
sad_enduser
|
yes
|
sad_domain
|
yes
|
no
|
|
|
|
|
sad_nbr
|
yes
|
no
|
|
|
|
|
sad_prefix
|
yes
|
no
|
|
|
|
|
sad_eu_nbr
|
yes
|
no
|
|
|
|
|
sad_line
|
yes
|
no
|
|
|
sad_eu_line
|
yes
|
sad_domain
|
yes
|
no
|
|
|
|
|
sad_nbr
|
yes
|
no
|
|
|
|
|
sad_prefix
|
yes
|
no
|
|
|
|
|
sad_line_type
|
yes
|
no
|
|
|
|
|
sad_eu_nbr
|
yes
|
no
|
|
|
|
|
sad_ui_line
|
yes
|
no
|
|
|
sad_line_eu
|
no
|
sad_domain
|
yes
|
no
|
|
|
|
|
sad_nbr
|
yes
|
no
|
|
|
|
|
sad_prefix
|
yes
|
no
|
|
|
|
|
sad_line_type
|
yes
|
no
|
|
|
|
|
sad_ui_line
|
yes
|
no
|
|
|
|
|
sad_eu_nbr
|
yes
|
no
|
|
∗
|
sad_nbrln
|
yes
|
sad_domain
|
yes
|
no
|
|
|
|
|
sad_nbr
|
yes
|
no
|
|
|
|
|
sad_prefix
|
yes
|
no
|
|
|
|
|
sad_line
|
yes
|
no
|
|
|
sad_part
|
no
|
sad_domain
|
yes
|
no
|
|
|
|
|
sad_for
|
yes
|
no
|
|
|
|
|
sad_serial
|
yes
|
no
|
|
|
|
|
sad_ref
|
yes
|
no
|
|
|
|
|
sad_nbr
|
yes
|
no
|
|
|
|
|
sad_prefix
|
yes
|
no
|
|
|
sad_prefix_type
|
no
|
sad_domain
|
yes
|
no
|
|
|
|
|
sad_prefix
|
yes
|
no
|
|
|
|
|
sad_eu_nbr
|
yes
|
no
|
|
|
|
|
sad_line_type
|
yes
|
no
|
|
|
sad_serial
|
no
|
sad_domain
|
yes
|
no
|
|
|
|
|
sad_prefix
|
yes
|
no
|
|
|
|
|
sad_serial
|
yes
|
no
|
|
|
Field Name
|
Label
|
Col-Label
|
Format
|
Dec
|
|
|
BudgetGroup_ID
|
Budget Group
|
|
-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
|
|
|
|
Saf_ID
|
Record ID
|
|
-99999999999
|
|
|
|
SafCode
|
SAF Code
|
|
x(20)
|
|
|
|
SafConcept_ID
|
SAF Concept Code
|
|
-99999999999
|
|
|
|
SafDescription
|
SAF Description
|
|
x(40)
|
|
|
|
SafIsActive
|
Active
|
|
yes/no
|
|
|
|
Index-Name
|
Uni
|
Field-Name
|
Asc
|
Abbr
|
|
|
BudgetGroupIdx
|
no
|
BudgetGroup_ID
|
yes
|
no
|
|
|
Code
|
no
|
SafCode
|
yes
|
no
|
|
|
CodeAndConcept
|
yes
|
SafConcept_ID
|
yes
|
no
|
|
|
|
|
SafCode
|
yes
|
no
|
|
|
Concept
|
no
|
SafConcept_ID
|
yes
|
no
|
|
|
IsActive
|
no
|
SafIsActive
|
yes
|
no
|
|
|
LastModIdx
|
no
|
LastModifiedDate
|
yes
|
no
|
|
∗
|
Prim
|
yes
|
Saf_ID
|
yes
|
no
|
|
|
ViewIndex
|
no
|
SafIsActive
|
yes
|
no
|
|
|
|
|
SafCode
|
yes
|
no
|