QAD 2017 Enterprise Edition > Technical References > Database Definitions >
  
AltTaskM
Warehousing Alternate Task Master
 
 
Field Name
Label
Col-Label
Format
Dec
 
AltTask
Alternate Task
Alt Task
x(8)
 
 
CmtIndx
Comments
 
>>>>>>>9
 
 
ConfMode
Confirmation Mode
Conf Mode
X(8)
 
 
CreateDate
Create Date
 
99/99/99
 
 
CreateUserID
Created
 
x(8)
 
 
Description
Description
 
x(24)
 
 
Domain
Domain
 
x(8)
 
 
FromLoc
From Location
From!Location
x(8)
 
 
FromSite
From Site
From!Site
x(8)
 
 
FromSLocGp
From SLocGrp
From!SLocGrp
x(8)
 
 
FromWhse
From Whse
From!Whse
x(8)
 
 
FromWLocGp
From WLocGrp
From!WLocGrp
x(8)
 
 
ModDate
Modified
 
99/99/99
 
 
ModUserID
Modified
 
x(8)
 
 
oid_AltTaskM
 
 
>>>>>>>>>>>>>>>>>>>>>>>>>>>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
 
QadI01
QAD Field
 
->,>>>,>>9
 
 
QadI02
QAD Field
 
->,>>>,>>9
 
 
QadI03
QAD Field
 
->,>>>,>>9
 
 
QadL01
QAD Field
 
yes/no
 
 
QadL02
QAD Field
 
yes/no
 
 
Task
Task
 
x(8)
 
 
TaskSeq
Sequence
 
>>>9
 
 
ToLoc
To Location
To Loc
x(8)
 
 
ToSite
To Site
 
x(8)
 
 
ToSLocGp
To SLocGrp
To!SLocGrp
x(8)
 
 
ToWhse
To Whse
 
x(8)
 
 
ToWLocGp
To WLocGrp
To!WLocGrp
x(8)
 
 
User1
User 1
 
x(8)
 
 
User2
User 2
 
x(8)
 
 
 
 
Index-Name
Uni
Field-Name
Asc
Abbr
AltTask
yes
Domain
yes
no
 
 
 
AltTask
yes
no
 
 
 
TaskSeq
yes
no
 
oid_AltTaskM
yes
oid_AltTaskM
yes
no
 
TaskSeq
no
Domain
yes
no
 
 
 
Task
yes
no
 
 
 
TaskSeq
yes
no
 
UsrIdx
no
Domain
yes
no
 
 
 
User1
yes
no
 
 
 
User2
yes
no
AltUMD
Warehousing Alternate Unit of Measure Detail
 
 
Field Name
Label
Col-Label
Format
Dec
 
ChangeAction
Change Action
Change!Action
>9
 
 
CreateDate
Create Date
 
99/99/99
 
 
CreateUserID
Created
 
x(8)
 
 
Domain
Domain
 
x(8)
 
 
ModDate
Modified
 
99/99/99
 
 
ModUserID
Modified
 
x(8)
 
 
NewUM
New UM
New!UM
x(2)
 
 
oid_AltUMD
 
 
>>>>>>>>>>>>>>>>>>>>>>>>>>>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
 
 
UM
UM
 
x(2)
 
 
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
AltUMD
yes
Domain
yes
no
 
 
 
UM
yes
no
 
 
 
NewUM
yes
no
 
oid_AltUMD
yes
oid_AltUMD
yes
no
 
UsrIdx
no
Domain
yes
no
 
 
 
User1
yes
no
 
 
 
User2
yes
no
AltUMM
Warehousing Alternate Unit of Measure Master
 
 
Field Name
Label
Col-Label
Format
Dec
 
AllowSplit
Allow Split
Split
yes/no
 
 
CmtIndx
Comments
 
>>>>>>>9
 
 
CreateDate
Create Date
 
99/99/99
 
 
CreateUserID
Created
 
x(8)
 
 
Description
Description
 
x(64)
 
 
Domain
Domain
 
x(8)
 
 
IDQty
ID Quantity
ID!Qty
>>>9
 
 
ModDate
Modified
 
99/99/99
 
 
ModUserID
Modified
 
x(8)
 
 
oid_AltUMM
 
 
>>>>>>>>>>>>>>>>>>>>>>>>>>>9.9<<<<<<<<<
10
 
Part
Item Number
 
x(18)
 
 
PrintID
Print ID
Print!ID
yes/no
 
 
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
 
 
RoundInspQty
Round Inspected Qty
 
yes/no
 
 
ShipType
Ship Type
Ship!Type
x(1)
 
 
SizeType
Sizing Type
T
x(1)
 
 
UM
UM
 
x(2)
 
 
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_AltUMM
yes
oid_AltUMM
yes
no
UM
yes
Domain
yes
no
 
 
 
UM
yes
no
 
UsrIdx
no
Domain
yes
no
 
 
 
User1
yes
no
 
 
 
User2
yes
no
al_mstr
Allocation Account Master
 
 
Field Name
Label
Col-Label
Format
Dec
 
al__qad01
 
 
99/99/99
 
 
al_code
Allocation Code
Allocatn
x(8)
 
 
al_desc
Description
 
x(24)
 
 
al_domain
Domain
 
x(8)
 
 
al_user1
Ufld1
 
x(8)
 
 
al_user2
Ufld2
 
x(8)
 
 
al_userid
User ID
 
x(8)
 
 
oid_al_mstr
 
 
>>>>>>>>>>>>>>>>>>>>>>>>>>>9.9<<<<<<<<<
10
 
 
 
Index-Name
Uni
Field-Name
Asc
Abbr
al_code
yes
al_domain
yes
no
 
 
 
al_code
yes
no
 
al_desc
no
al_domain
yes
no
 
 
 
al_desc
yes
no
 
 
 
al_code
yes
no
 
oid_al_mstr
yes
oid_al_mstr
yes
no
anl_det
Analysis Code Link Detail
 
 
Field Name
Label
Col-Label
Format
Dec
 
anl__qadc01
 
 
x(8)
 
 
anl__qadd01
 
 
->>>,>>>,>>9.9<<<
10
 
anl_code
Code
 
x(18)
 
 
anl_desc
Description
 
x(24)
 
 
anl_domain
Domain
 
x(8)
 
 
anl_link_code
Linked Code
Link-to
x(18)
 
 
anl_type
Type
 
x(24)
 
 
anl_user1
Ufld1
 
x(8)
 
 
anl_user2
Ufld2
 
x(8)
 
 
oid_anl_det
 
 
>>>>>>>>>>>>>>>>>>>>>>>>>>>9.9<<<<<<<<<
10
 
 
 
Index-Name
Uni
Field-Name
Asc
Abbr
 
anl_link_code
no
anl_domain
yes
no
 
 
 
anl_type
yes
no
 
 
 
anl_link_code
yes
no
anl_type_code
yes
anl_domain
yes
no
 
 
 
anl_type
yes
no
 
 
 
anl_code
yes
no
 
 
 
anl_link_code
yes
no
 
oid_anl_det
yes
oid_anl_det
yes
no
ans_det
Analysis Code Selection Detail
 
 
Field Name
Label
Col-Label
Format
Dec
 
ans__qadc01
 
 
x(8)
 
 
ans__qadd01
 
 
->>>,>>>,>>9.9<<<
10
 
ans_code
Code
 
x(18)
 
 
ans_domain
Domain
 
x(8)
 
 
ans_field
Condition Field
 
x(32)
 
 
ans_include
Include
 
yes/no
 
 
ans_mask
Wildcard
 
x(28)
 
 
ans_sel_high
To
 
x(28)
 
 
ans_sel_low
From
 
x(28)
 
 
ans_type
Type
 
x(24)
 
 
ans_user1
Ufld1
 
x(8)
 
 
ans_user2
Ufld2
 
x(8)
 
 
oid_ans_det
 
 
>>>>>>>>>>>>>>>>>>>>>>>>>>>9.9<<<<<<<<<
10
 
 
 
Index-Name
Uni
Field-Name
Asc
Abbr
ans_type_code
yes
ans_domain
yes
no
 
 
 
ans_type
yes
no
 
 
 
ans_code
yes
no
 
 
 
ans_field
yes
no
 
 
 
ans_sel_low
yes
no
 
oid_ans_det
yes
oid_ans_det
yes
no
anx_det
Analysis Code Exploded Detail
 
 
Field Name
Label
Col-Label
Format
Dec
 
anx__qadc01
 
 
x(8)
 
 
anx__qadd01
 
 
->>>,>>>,>>9.9<<<
10
 
anx_active
Active
 
yes/no
 
 
anx_code
Code
 
x(18)
 
 
anx_domain
Domain
 
x(8)
 
 
anx_node
Node
 
x(18)
 
 
anx_type
Type
 
x(24)
 
 
anx_user1
Ufld1
 
x(8)
 
 
anx_user2
Ufld2
 
x(8)
 
 
oid_anx_det
 
 
>>>>>>>>>>>>>>>>>>>>>>>>>>>9.9<<<<<<<<<
10
 
 
 
Index-Name
Uni
Field-Name
Asc
Abbr
 
anx_active
yes
anx_domain
yes
no
 
 
 
anx_type
yes
no
 
 
 
anx_node
yes
no
 
 
 
anx_active
yes
no
 
 
 
anx_code
yes
no
 
anx_node
yes
anx_domain
yes
no
 
 
 
anx_type
yes
no
 
 
 
anx_node
yes
no
 
 
 
anx_code
yes
no
anx_type_code
yes
anx_domain
yes
no
 
 
 
anx_type
yes
no
 
 
 
anx_code
yes
no
 
 
 
anx_node
yes
no
 
oid_anx_det
yes
oid_anx_det
yes
no
an_mstr
Analysis Code Master
 
 
Field Name
Label
Col-Label
Format
Dec
 
an__qadc01
 
 
x(8)
 
 
an__qadd01
 
 
->>>,>>>,>>9.9<<<
10
 
an_active
Active
 
yes/no
 
 
an_cmtindx
Comment Index
Comment
>>>>>>9
 
 
an_code
Code
 
x(18)
 
 
an_desc
Description
 
x(24)
 
 
an_domain
Domain
 
x(8)
 
 
an_mod_date
Modified Date
Mod Date
99/99/99
 
 
an_sec_group
Security Role
 
x(189)
 
 
an_type
Type
 
x(24)
 
 
an_user1
Ufld1
 
x(8)
 
 
an_user2
Ufld2
 
x(8)
 
 
an_userid
User ID
 
x(8)
 
 
oid_an_mstr
 
 
>>>>>>>>>>>>>>>>>>>>>>>>>>>9.9<<<<<<<<<
10
 
 
 
Index-Name
Uni
Field-Name
Asc
Abbr
 
an_code_type
yes
an_domain
yes
no
 
 
 
an_code
yes
no
 
 
 
an_type
yes
no
an_type_code
yes
an_domain
yes
no
 
 
 
an_type
yes
no
 
 
 
an_code
yes
no
 
oid_an_mstr
yes
oid_an_mstr
yes
no
apc_ctrl
Accounts Payable Control
 
 
Field Name
Label
Col-Label
Format
Dec
 
apc__qad01
 
 
>>>>>>9
 
 
apc__qad02
 
 
99/99/99
 
 
apc__qad03
 
 
x(8)
 
 
apc__qad04
External Memo References Allowed
 
yes/no
 
 
apc__qadc01
 
 
x(8)
 
 
apc__qadc02
 
 
x(4)
 
 
apc__qadc03
 
 
x(24)
 
 
apc__qadc04
 
 
x(24)
 
 
apc__qadc05
 
 
x(24)
 
 
apc__qadi01
 
 
->>>>>>>9
 
 
apc_approv
Use Assigned-To Field
 
yes/no
 
 
apc_bank
Default Bank
Bank
x(2)
 
 
apc_batch
Next Batch
Batch
>>>>>>>9
 
 
apc_ckfrm
Check Form
 
x(2)
 
 
apc_confirm
Enter Vouchers Confirmed
 
yes/no
 
 
apc_domain
Domain
 
x(8)
 
 
apc_ers_cn_dybk
ERS Credit Note Daybook
ERS Credit!Note Daybook
x(8)
 
 
apc_ers_inv_dybk
ERS Invoice Daybook
ERS!Invoice Daybook
x(8)
 
 
apc_ers_ps_err
ERS Packing Slip Error
P/S!Err
yes/no
 
 
apc_ers_vo_tp
ERS Voucher Date Option
ERS!VDO
>9
 
 
apc_ex_ratetype
Rate Type
 
x(8)
 
 
apc_ex_tol
Exchange Tolerance
 
>9.99%
10
 
apc_expvar
Use Expensed Item Var Accts
 
yes/no
 
 
apc_ext_ref
External Voucher References Allowed
 
yes/no
 
 
apc_gl_avg_cst
Update GL Average Cost
Avg!Cst
yes/no
 
 
apc_gl_sum
Summarized Journal
Summ Jrnl
yes/no
 
 
apc_holdinvoiceamt
Put variance amount on hold
 
yes/no
 
 
apc_invoice_temp_pl
Match Receipts with Temporary Price
 
yes/no
 
 
apc_jrnl
Next Journal
Journl
999999
 
 
apc_multi_entity_pay
Multi-Entity Payments
 
yes/no
 
 
apc_pip
Use Payment In Process Acct
PIP
yes/no
 
 
apc_recalc_tax
Recalculate Tax Rates
Recalc!Tax
yes/no
 
 
apc_rv_conf
Release Recur VOs Confirmed
 
yes/no
 
 
apc_ship
Ship-To
 
x(8)
 
 
apc_sum_lvl
AP Summarization Level
AP!Summ!Lvl
9
 
 
apc_use_drft
Use Draft Management
Use!DM
yes/no
 
 
apc_user1
Ufld1
 
x(8)
 
 
apc_user2
Ufld2
 
x(8)
 
 
apc_vchr_all
Voucher All
 
yes/no
 
 
apc_vo_pre
Voucher Prefix
Pre
x(3)
 
 
apc_voucher
Next Voucher
Voucher
>>>>>>>9
 
 
oid_apc_ctrl
 
 
>>>>>>>>>>>>>>>>>>>>>>>>>>>9.9<<<<<<<<<
10
 
 
 
Index-Name
Uni
Field-Name
Asc
Abbr
apc_index1
yes
apc_domain
yes
no
 
oid_apc_ctrl
yes
oid_apc_ctrl
yes
no
APMatching
Accounts Payable Matching
 
 
Field Name
Label
Col-Label
Format
Dec
 
APMatching_ID
Record ID
 
-99999999999
 
 
APMatchingAINRecTaxTC
Non-recoverable Invoice Tax
 
->>>,>>>,>>>,>>9.99
4
 
APMatchingAIRecTaxTC
Recoverable Invoice Tax
 
->>>,>>>,>>>,>>9.99
4
 
APMatchingARNRecTaxTC
Non-recoverable Receipt Tax
 
->>>,>>>,>>>,>>9.99
4
 
APMatchingARRecTaxTC
Recoverable Receipt Tax
 
->>>,>>>,>>>,>>9.99
4
 
APMatchingCInvoiceDiscPct
Discount Percentage
 
->>9.99
2
 
APMatchingDate
Date
Matching Date
99/99/9999
 
 
APMatchingStatus
Status
 
x(20)
 
 
APMatchingTaxEnv
Tax Environment
 
x(16)
 
 
APMatchingTotalAmountLC
BC to Allocate
 
->>>,>>>,>>>,>>9.99
4
 
APMatchingTotalAmountTC
TC to Allocate
TC to Allocate
->>>,>>>,>>>,>>9.99
4
 
CInvoice_ID
Voucher
 
-99999999999
 
 
CirecPostingLine_ID
Link to PostingLine
 
-99999999999
 
 
Company_ID
Link to Company
 
-99999999999
 
 
Currency_ID
Currency Code
Curr
-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
 
-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)
 
 
Period_ID
GL Period
GL Pd
-99999999999
 
 
Posting_ID
Voucher
 
-99999999999
 
 
QADC01
 
 
x(40)
 
 
QADC02
 
 
x(255)
 
 
QADD01
 
 
->,>>>,>>9.9999
10
 
QADT01
 
 
99/99/9999
 
 
Reason_ID
Invoice Status Code
 
-99999999999
 
 
 
 
Index-Name
Uni
Field-Name
Asc
Abbr
 
CInvoice
no
CInvoice_ID
yes
no
 
CirecPostingLine
no
CirecPostingLine_ID
yes
no
 
Company
no
Company_ID
yes
no
 
CurrencyIdx
no
Currency_ID
yes
no
 
Journal
no
Journal_ID
yes
no
 
MatchingDate
no
Company_ID
yes
no
 
 
 
APMatchingDate
yes
no
 
Period
no
Period_ID
yes
no
 
PostingIdx
no
Posting_ID
yes
no
 ∗
Prim
yes
APMatching_ID
yes
no
 
Reason
no
Reason_ID
yes
no
 
StatusIdx
no
APMatchingStatus
yes
no
 
UniqueIdx
yes
Company_ID
yes
no
 
 
 
CInvoice_ID
yes
no
APmatchingLn
Accounts Payable Matching Line
 
 
Field Name
Label
Col-Label
Format
Dec
 
APMatching_ID
Link to APMatching
 
-99999999999
 
 
APmatchingLn_ID
Record ID
 
-99999999999
 
 
APmatchingLnIsPvodFinished
Finished
 
yes/no
 
 
APMatchingLnIsTaxable
Taxable
 
yes/no
 
 
APMatchingLnIsVarGLPosting
Use GL Var Account
 
yes/no
 
 
APMatchingLnMatchAmtCC
SC Matched Amount
 
->>>,>>>,>>>,>>9.99
4
 
APMatchingLnMatchAmtLC
BC Matched Amount
 
->>>,>>>,>>>,>>9.99
4
 
APMatchingLnMatchAmtTC
TC Matched Amount
 
->>>,>>>,>>>,>>9.99
4
 
APMatchingLnMatchAmtTxInTC
TC Matched Amount (incl Tax)
 
->>>,>>>,>>>,>>9.99
4
 
APMatchingLnMatchIsTaxIncl
Tax Included
 
yes/no
 
 
APMatchingLnMatchQty
Matched Quantity
 
->>>,>>>,>>9.99999
10
 
APMatchingLnMatchUnitPrice
Matched Unit Price
 
->>>,>>>,>>9.99999
10
 
APMatchingLnMatchUnitPrNT
Matched Unit Price (excl Tax)
 
->>>,>>>,>>9.99999
10
 
APMatchingLnOpAllocCode
Op Alloc Code
 
x(8)
 
 
APMatchingLnPvodAccruedTC
TC Accrued Amount
 
->>>,>>>,>>>,>>9.99
4
 
APMatchingLnPvodAdjustRef
Adjustment Ref
 
x(50)
 
 
APMatchingLnPvodCCCode
Cost Center (Pinv)
 
x(20)
 
 
APMatchingLnPvodCCRate
Exchange Rate (SC)
Exch Rate (CC)
->,>>>,>>9.9999999999
10
 
APMatchingLnPvodCCScale
Rate Scale (SC)
 
->,>>>,>>9.9999999999
10
 
APMatchingLnPvodCompCode
Entity Code
 
x(20)
 
 
APMatchingLnPvodCompID
Entity ID
 
-99999999999
 
 
APMatchingLnPvodConvFactor
Conv Factor (UM)
 
->,>>>,>>9.99
8
 
APMatchingLnPvodCostMtdCur
Current Cost Method
 
x(20)
 
 
APMatchingLnPvodCostMtdGL
GL Cost Method
 
x(20)
 
 
APMatchingLnPvodCurrency
Currency
Curr
x(20)
 
 
APMatchingLnPvodDivCode
Sub-Account (Pinv)
Sub-Acct (Pinv)
x(20)
 
 
APMatchingLnPvodExchRate
Exchange Rate
Exch Rate
->,>>>,>>9.9999999999
10
 
APMatchingLnPvodExchRate2
Exchange Rate 2
Exch Rate 2
->,>>>,>>9.9999999999
10
 
APMatchingLnPvodExtRef
External Ref
Ext Ref
x(50)
 
 
APMatchingLnPvodFromTaxZone
From Tax Zone (pvo)
 
x(16)
 
 
APMatchingLnPvodGLCode
Account (Pinv)
 
x(20)
 
 
APMatchingLnPvodIntRef
Internal Ref
 
x(50)
 
 
APMatchingLnPvodInvoicedTC
TC Invoiced Amount
 
->>>,>>>,>>>,>>9.99
4
 
APMatchingLnPvodIsLgCharge
Log Charge
 
yes/no
 
 
APMatchingLnPvodIsTaxable
Taxable (pvo)
 
yes/no
 
 
APMatchingLnPvodIsTaxIncl
Tax Included
 
yes/no
 
 
APMatchingLnPvodIsTempPrice
Temporary Price
 
yes/no
 
 
APMatchingLnPvodItem
Item
 
x(20)
 
 
APMatchingLnPvodItemDescr1
Item Description
Item Desc
x(24)
 
 
APMatchingLnPvodItemDescr2
Item Description (2)
Item Desc (2)
x(24)
 
 
APMatchingLnPvodItemType
Item Type
 
x(20)
 
 
APMatchingLnPvodLgCharge
Logistic Charge
 
x(20)
 
 
APMatchingLnPvodOpAllocCode
Op Alloc Code (Pinv)
 
x(8)
 
 
APMatchingLnPvodOpenAmtTC
TC Open Amt
 
->>>,>>>,>>>,>>9.99
4
 
APMatchingLnPvodOpenQty
Open Quantity
 
->>>,>>>,>>9.99999
10
 
APMatchingLnPvodOrder
Order
 
x(20)
 
 
APMatchingLnPvodOrderLnNbr
Order Line Nbr
 
->,>>>,>>9
 
 
APMatchingLnPvodOrderType
Order Type
 
x(20)
 
 
APMatchingLnPvodPackingQty
Packing Slip Qty
 
->>>,>>>,>>9.99999
10
 
APMatchingLnPvodPayCond
Credit Terms
 
x(8)
 
 
APMatchingLnPvodPLidLine
PLI Line
 
->,>>>,>>9
 
 
APMatchingLnPvodPLiKeyId
PLI Key
 
->,>>>,>>9
 
 
APMatchingLnPvodPrjCode
Project (Pinv)
 
x(20)
 
 
APMatchingLnPvodReceiptQty
Receipt Quantity
Receipt Qty
->>>,>>>,>>9.99999
10
 
APMatchingLnPvodSite
Site
 
x(20)
 
 
APMatchingLnPvodSupplier
Supplier
 
x(8)
 
 
APMatchingLnPvodSupplItem
Supplier Item
 
x(30)
 
 
APMatchingLnPvodTaxClass
Tax Class (pvo)
 
x(3)
 
 
APMatchingLnPvodTaxEnv
Tax Env (pvo)
 
x(16)
 
 
APMatchingLnPvodTaxUsage
Tax Usage (pvo)
 
x(8)
 
 
APMatchingLnPvodToTaxZone
To Tax Zone (pvo)
 
x(16)
 
 
APMatchingLnPvodTransDate
Transaction Date
 
99/99/9999
 
 
APMatchingLnPvodTransType
Transaction Type
 
x(2)
 
 
APMatchingLnPvodUnitPrice
Unit Price
 
->>>,>>>,>>9.99999
10
 
APMatchingLnPvodUnitPrNT
Unit Price (excl Tax)
 
->>>,>>>,>>9.99999
10
 
APMatchingLnPvodUoM
GL Unit of Measure
UM
x(20)
 
 
APMatchingLnPvodUoMConv
UM Conversion factor
 
->,>>>,>>9.99
10
 
APMatchingLnReceiptAmtCC
SC Receipt Amount
 
->>>,>>>,>>>,>>9.99
4
 
APMatchingLnReceiptAmtLC
BC Receipt Amt
 
->>>,>>>,>>>,>>9.99
4
 
APMatchingLnReceiptAmtTC
TC Receipt Amt
 
->>>,>>>,>>>,>>9.99
4
 
APMatchingLnTaxClass
Tax Class
 
x(3)
 
 
APMatchingLnTaxEnv
Tax Env
 
x(16)
 
 
APMatchingLnTaxUsage
Tax Usage
 
x(8)
 
 
APMatchingLnVarExchRateCC
SC Exch Rate Variance
 
->>>,>>>,>>>,>>9.99
4
 
APMatchingLnVarExchRateLC
BC Exch Rate Variance
 
->>>,>>>,>>>,>>9.99
4
 
APMatchingLnVarRateCC
SC Rate Variance
 
->>>,>>>,>>>,>>9.99
4
 
APmatchingLnVarRateLC
BC Rate Variance
 
->>>,>>>,>>>,>>9.99
4
 
APmatchingLnVarRateTC
TC Rate Variance
 
->>>,>>>,>>>,>>9.99
4
 
APMatchingLnVarUsageCC
SC Usage Variance
 
->>>,>>>,>>>,>>9.99
4
 
APmatchingLnVarUsageLC
BC Usage Variance
 
->>>,>>>,>>>,>>9.99
4
 
APmatchingLnVarUsageTC
TC Usage Variance
 
->>>,>>>,>>>,>>9.99
4
 
CostCentre_ID
Cost Center
 
-99999999999
 
 
Division_ID
Sub-Account
Sub-Acct
-99999999999
 
 
GL_ID
Account
 
-99999999999
 
 
NewExpensePostingLine_ID
Link to PostingLine
 
-99999999999
 
 
Project_ID
Project Code
 
-99999999999
 
 
PvodLineID
Pinv Line ID
Pvo Line ID
-99999999999
 
 
PvoDomain
Domain
 
x(8)
 
 
PvoID
Pinv ID
Pvo ID
-99999999999
 
 
PvoPostingLine_ID
Link to PostingLine
 
-99999999999
 
 
QADC01
 
 
x(40)
 
 
QADC02
 
 
x(255)
 
 
QADD01
 
 
->,>>>,>>9.9999
10
 
QADT01
 
 
99/99/9999
 
 
RevExpensePostingLine_ID
Link To PostingLine
 
-99999999999
 
 
VarExchRatCCPostingLine_ID
SC Exch Rate Posting Line
 
-99999999999
 
 
VarExchRatePostingLine_ID
Exch Rate Posting Line
 
-99999999999
 
 
VarRatePostingLine_ID
Link to PostingLine
 
-99999999999
 
 
VarUsagePostingLine_ID
Link to PostingLine
 
-99999999999
 
 
 
 
Index-Name
Uni
Field-Name
Asc
Abbr
 
APMatching
no
APMatching_ID
yes
no
 
CostCentre
no
CostCentre_ID
yes
no
 
Division
no
Division_ID
yes
no
 
DomainPvodLine
no
PvoDomain
yes
no
 
 
 
PvoID
yes
no
 
 
 
PvodLineID
yes
no
 
ExRateCCPL
no
VarExchRatCCPostingLine_ID
yes
no
 
ExRateLCPL
no
VarExchRatePostingLine_ID
yes
no
 
GL
no
GL_ID
yes
no
 
NewExpPL
no
NewExpensePostingLine_ID
yes
no
 ∗
Prim
yes
APmatchingLn_ID
yes
no
 
Project
no
Project_ID
yes
no
 
PvoPL
no
PvoPostingLine_ID
yes
no
 
RatePL
no
VarRatePostingLine_ID
yes
no
 
RevExpPL
no
RevExpensePostingLine_ID
yes
no
 
UniqueIdx
yes
APMatching_ID
yes
no
 
 
 
PvoID
yes
no
 
 
 
PvodLineID
yes
no
 
UsagePL
no
VarUsagePostingLine_ID
yes
no
APMatchingLnRevTax
Accounts Payable Matching Line Rev Tax
 
 
Field Name
Label
Col-Label
Format
Dec
 
APMatching_ID
Link to APMatching
 
-99999999999
 
 
APMatchingLn_ID
Link to APMatchingLn
 
-99999999999
 
 
APMatchingLnRevTax_ID
Record ID
 
-99999999999
 
 
PostingLine_ID
Link to PostingLine
 
-99999999999
 
 
QADC01
 
 
x(40)
 
 
QADC02
 
 
x(255)
 
 
QADD01
 
 
->,>>>,>>9.9999
10
 
QADT01
 
 
99/99/9999
 
 
 
 
Index-Name
Uni
Field-Name
Asc
Abbr
 
APMatch
no
APMatching_ID
yes
no
 
PostLine
no
PostingLine_ID
yes
no
 ∗
Prim
yes
APMatchingLnRevTax_ID
yes
no
 
UniqIdx
yes
APMatchingLn_ID
yes
no
 
 
 
PostingLine_ID
yes
no
APMatchingLnTax
Accounts Payable Matching Line Tax Detai
 
 
Field Name
Label
Col-Label
Format
Dec
 
AbsRetTaxDivision_ID
Retained Tax Sub-Account
Retained Tax Sub-Acct
-99999999999
 
 
AbsRetTaxGL_ID
Retained Tax Account
 
-99999999999
 
 
AbsRetTaxPostingLine_ID
Link to PostingLine
 
-99999999999
 
 
APMatching_ID
Link to APMatching
 
-99999999999
 
 
APMatchingLn_ID
Link to APMatchingLn
 
-99999999999
 
 
APMatchingLnTax_ID
Record ID
 
-99999999999
 
 
APMatchingLnTaxAINRecTaxTC
TC Non Recov Tax Accrued at Invoice
 
->>>,>>>,>>>,>>9.99
4
 
APMatchingLnTaxAIRecTaxTC
TC Recoverable Tax Accrued at Invoice
 
->>>,>>>,>>>,>>9.99
4
 
APMatchingLnTaxARNRecTaxTC
TC Non Recov Tax Accrued at Receipt
 
->>>,>>>,>>>,>>9.99
4
 
APMatchingLnTaxARRecTaxTC
TC Recov Tax Accrued at Receipt
 
->>>,>>>,>>>,>>9.99
4
 
APMatchingLnTaxBaseLC
LC Tax Base
 
->>>,>>>,>>>,>>9.99
4
 
APMatchingLnTaxBaseTC
TC Tax Base
 
->>>,>>>,>>>,>>9.99
4
 
APMatchingLnTaxIsAbsRet
Absorbed or Retained Tax
 
yes/no
 
 
APMatchingLnTaxIsAccrRcp
Accrue at Receipt or Usage
 
yes/no
 
 
APMatchingLnTaxIsDiscAtInv
Discount Tax at Invoice
 
yes/no
 
 
APMatchingLnTaxIsRevCharge
Reverse Charge
 
yes/no
 
 
APMatchingLnTaxIsSuspDel
Delayed Tax
Delay Tax
yes/no
 
 
APMatchingLnTaxIsTaxIncl
Tax Incl
 
yes/no
 
 
APMatchingLnTaxIsTIAllowed
Allow Tax Included
 
yes/no
 
 
APMatchingLnTaxIsUpdAllow
Update Tax Allowed
 
yes/no
 
 
APMatchingLnTaxRecovTaxPct
Recoverable Tax Percentage
 
->>9.99
2
 
APMatchingLnTaxTaxLC
LC Tax
 
->>>,>>>,>>>,>>9.99
4
 
APMatchingLnTaxTaxPct
Tax Percentage
 
->>9.99
2
 
APMatchingLnTaxTaxTC
TC Tax
 
->>>,>>>,>>>,>>9.99
4
 
APMatchingLnTaxTaxTrType
Tax Transaction Type
 
x(2)
 
 
APMatchingLnTaxTaxType
Tax Type
 
x(16)
 
 
APRatePostingLine_ID
Link to PostingLine
 
-99999999999
 
 
NormalTaxDivision_ID
Normal Tax Sub-Account
Normal Tax Sub-Acct
-99999999999
 
 
NormalTaxGL_ID
Normal Tax Account
Tax Account
-99999999999
 
 
NormalTaxPostingLine_ID
Link to PostingLine
 
-99999999999
 
 
PPVPostingLine_ID
Link to PostingLine
 
-99999999999
 
 
QADC01
 
 
x(40)
 
 
QADC02
 
 
x(255)
 
 
QADD01
 
 
->,>>>,>>9.9999
10
 
QADT01
 
 
99/99/9999
 
 
SuspDelTaxDivision_ID
Delayed Tax Sub-Account
Delay Tax Sub-Acct
-99999999999
 
 
SuspDelTaxGL_ID
Delayed Tax Account
Delay Tax Acct
-99999999999
 
 
Vat_ID
Tax Code
 
-99999999999
 
 
 
 
Index-Name
Uni
Field-Name
Asc
Abbr
 
AbsRetPL
no
AbsRetTaxPostingLine_ID
yes
no
 
AbsRetTaxDiv
no
AbsRetTaxDivision_ID
yes
no
 
AbsRetTaxGL
no
AbsRetTaxGL_ID
yes
no
 
APMatching
no
APMatching_ID
yes
no
 
ApMatchingLn
no
APMatchingLn_ID
yes
no
 
APRatePL
no
APRatePostingLine_ID
yes
no
 
NormalTaxDiv
no
NormalTaxDivision_ID
yes
no
 
NormalTaxGL
no
NormalTaxGL_ID
yes
no
 
NormalTaxPL
no
NormalTaxPostingLine_ID
yes
no
 
PPVPL
no
PPVPostingLine_ID
yes
no
 ∗
Prim
yes
APMatchingLnTax_ID
yes
no
 
TaxDivIdx
no
SuspDelTaxDivision_ID
yes
no
 
TaxGLdx
no
SuspDelTaxGL_ID
yes
no
 
Vat
no
Vat_ID
yes
no
APMatchingLnWHT
Accounts Payable Matching Line Tax Detail
 
 
Field Name
Label
Col-Label
Format
Dec
 
APMatching_ID
Link to APMatching
 
-99999999999
 
 
APMatchingLn_ID
Link to APMatchingLn
 
-99999999999
 
 
APMatchingLnTax_ID
Link To APMatchingLnTax
 
-99999999999
 
 
APMatchingLnWHT_ID
Record ID
 
-99999999999
 
 
APMatchingLnWHTAmtCredLC
BC WHT Amt (CR)
 
->>>,>>>,>>>,>>9.99
4
 
APMatchingLnWHTAmtCredTC
TC WHT Amt (CR)
 
->>>,>>>,>>>,>>9.99
4
 
APMatchingLnWHTAmtDebLC
BC WHT Amt (DR)
 
->>>,>>>,>>>,>>9.99
4
 
APMatchingLnWHTAmtDebTC
TC WHT Amt (DR)
 
->>>,>>>,>>>,>>9.99
4
 
APMatchingLnWHTBaseTaxPct
Tax Base Percentage
 
->>9.99
2
 
APMatchingLnWHTExpCredTC
TC Expense (CR)
 
->>>,>>>,>>>,>>9.99
4
 
APMatchingLnWHTExpDebTC
TC Expense (DR)
 
->>>,>>>,>>>,>>9.99
4
 
APMatchingLnWHTFeeCredTC
TC Fee (CR)
 
->>>,>>>,>>>,>>9.99
4
 
APMatchingLnWHTFeeDebTC
TC Fee (DR)
 
->>>,>>>,>>>,>>9.99
4
 
APMatchingLnWHTIsUpdAllow
Update Tax Allowed
 
yes/no
 
 
APMatchingLnWHTRecovTaxPct
Recoverable Tax Percentage
 
->>9.99
2
 
APMatchingLnWHTTaxPct
Tax Percentage
 
->>9.99
2
 
APMatchingLnWHTTaxTrType
Transaction Type
 
x(2)
 
 
APMatchingLnWHTTaxType
Tax Type
 
x(20)
 
 
APMatchingLnWHTTxFeeCredLC
BC Taxable Fee (CR)
 
->>>,>>>,>>>,>>9.99
4
 
APMatchingLnWHTTxFeeCredTC
TC Taxable Fee (CR)
 
->>>,>>>,>>>,>>9.99
4
 
APMatchingLnWHTTxFeeDebLC
BC Taxable Fee (DR)
 
->>>,>>>,>>>,>>9.99
4
 
APMatchingLnWHTTxFeeDebTC
TC Taxable Fee (DR)
 
->>>,>>>,>>>,>>9.99
4
 
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)
 
 
Division_ID
Link To Division
 
-99999999999
 
 
GL_ID
Link To GL
 
-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
 
 
Vat_ID
Link to Vat
 
-99999999999
 
 
 
 
Index-Name
Uni
Field-Name
Asc
Abbr
 
APMatching
no
APMatching_ID
yes
no
 
APMatchingLn
no
APMatchingLn_ID
yes
no
 
CombiNonUni
no
APMatchingLn_ID
yes
no
 
 
 
APMatchingLnTax_ID
yes
no
 
 
 
Vat_ID
yes
no
 
Division
no
Division_ID
yes
no
 
GL
no
GL_ID
yes
no
 ∗
Prim
yes
APMatchingLnWHT_ID
yes
no
 
Vat
no
Vat_ID
yes
no
apmr_mstr
Advanced Pricing Management Customer Relationship Master
 
 
Field Name
Label
Col-Label
Format
Dec
 
apmr__qadc01
 
 
x(8)
 
 
apmr__qadc02
 
 
x(8)
 
 
apmr__qadc03
 
 
x(8)
 
 
apmr__qadd01
 
 
->>>>,>>>,>>9.9
10
 
apmr__qadd02
 
 
->>>>,>>>,>>9.9
10
 
apmr__qadi01
 
 
->,>>>,>>9
 
 
apmr__qadi02
 
 
->,>>>,>>9
 
 
apmr__qadl01
 
 
yes/no
 
 
apmr__qadl02
 
 
yes/no
 
 
apmr__qadt01
 
 
99/99/99
 
 
apmr__qadt02
 
 
99/99/99
 
 
apmr_domain
Domain
 
x(8)
 
 
apmr_pricing
Pricing
 
>9
 
 
apmr_rule
Rule
 
>9
 
 
apmr_seq
Sequence
 
>>9
 
 
apmr_type
Type
 
>>>9
 
 
apmr_user1
Ufld1
 
x(8)
 
 
apmr_user2
Ufld2
 
x(8)
 
 
oid_apmr_mstr
 
 
>>>>>>>>>>>>>>>>>>>>>>>>>>>9.9<<<<<<<<<
10
 
 
 
Index-Name
Uni
Field-Name
Asc
Abbr
apmr_seq
yes
apmr_domain
yes
no
 
 
 
apmr_seq
yes
no
 
apmr_type
yes
apmr_domain
yes
no
 
 
 
apmr_type
yes
no
 
oid_apmr_mstr
yes
oid_apmr_mstr
yes
no
apm_ctrl
Advanced Pricing Management Control
 
 
Field Name
Label
Col-Label
Format
Dec
 
apm__qadc01
 
 
x(8)
 
 
apm__qadc02
 
 
x(8)
 
 
apm__qadc03
 
 
x(8)
 
 
apm__qadd01
 
 
->>>>,>>>,>>9.9
10
 
apm__qadd02
 
 
->>>>,>>>,>>9.9
10
 
apm__qadi01
 
 
->,>>>,>>9
 
 
apm__qadi02
 
 
->,>>>,>>9
 
 
apm__qadi03
 
 
->>>>>>>9
 
 
apm__qadl01
 
 
yes/no
 
 
apm__qadl02
 
 
yes/no
 
 
apm__qadl03
 
 
yes/no
 
 
apm__qadt01
 
 
99/99/99
 
 
apm__qadt02
 
 
99/99/99
 
 
apm_div
Default Division
 
x(8)
 
 
apm_domain
Domain
 
x(8)
 
 
apm_line_rel
Line Relationships
 
yes/no
 
 
apm_manual
Manual P/L Selection
 
yes/no
 
 
apm_multi_div
Multiple Divisions
 
yes/no
 
 
apm_plpri
P/L Priorities
 
yes/no
 
 
apm_plpri_dseq
P/L Display Seq
 
x(20)
 
 
apm_plpri_sseq
P/L Select Seq
 
x(20)
 
 
apm_prig1
Pricing Group 1
 
yes/no
 
 
apm_prig2
Pricing Group 2
 
yes/no
 
 
apm_user1
Ufld1
 
x(8)
 
 
apm_user2
Ufld2
 
x(8)
 
 
oid_apm_ctrl
 
 
>>>>>>>>>>>>>>>>>>>>>>>>>>>9.9<<<<<<<<<
10
 
 
 
Index-Name
Uni
Field-Name
Asc
Abbr
apm_index1
yes
apm_domain
yes
no
 
oid_apm_ctrl
yes
oid_apm_ctrl
yes
no
ApproveStatusTrans
Approve Status Transition
 
 
Field Name
Label
Col-Label
Format
Dec
 
ApproveStatusTrans_ID
Record ID
 
-99999999999
 
 
ApproveStatusTransFrStatus
From Status
 
x(40)
 
 
ApproveStatusTransToStatus
To Status
 
x(40)
 
 
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)
 
 
QADC01
 
 
x(40)
 
 
QADC02
 
 
x(255)
 
 
QADD01
 
 
->,>>>,>>9.9999
10
 
QADT01
 
 
99/99/9999
 
 
 
 
Index-Name
Uni
Field-Name
Asc
Abbr
 
Company
no
Company_ID
yes
no
 ∗
Prim
yes
ApproveStatusTrans_ID
yes
no
 
UniqueIdx
yes
Company_ID
yes
no
 
 
 
ApproveStatusTransFrStatus
yes
no
 
 
 
ApproveStatusTransToStatus
yes
no
arc_ctrl
Accounts Receivable Control
 
 
Field Name
Label
Col-Label
Format
Dec
 
arc__qad01
 
 
>>>>>>9
 
 
arc__qad02
 
 
99/99/99
 
 
arc__qad03
 
 
x(8)
 
 
arc__qadc01
 
 
x(8)
 
 
arc__qadc02
 
 
x(4)
 
 
arc__qadc03
 
 
x(24)
 
 
arc__qadc04
 
 
x(24)
 
 
arc__qadc05
 
 
x(24)
 
 
arc__qadi01
 
 
->>>>>>>9
 
 
arc_auto_drft
Auto Post Drafts
Auto!Post
yes/no
 
 
arc_auto_late_int
Auto Calculate Late Interest
Auto!Late!Int
yes/no
 
 
arc_batch
Next Batch
Batch
99999999
 
 
arc_coll_mthd
Collection Method
M
x(1)
 
 
arc_domain
Domain
 
x(8)
 
 
arc_drft_acc
Drafts Receivable Account
Drft Rcv
x(8)
 
 
arc_drft_cc
Drafts Receivable Cost Center
CC
x(4)
 
 
arc_drft_max
Max Draft Amt
 
->>>>,>>>,>>9.99
10
 
arc_drft_min
Min Draft Amt
 
->>>>,>>>,>>9.99
10
 
arc_drft_sub
Drafts Receivable Sub
Sub-Acct
x(8)
 
 
arc_ex_ratetype
Rate Type
 
x(8)
 
 
arc_ex_tol
Exchange Tolerance
 
>9.99%
10
 
arc_ext_drft_ref
External Draft Ref Allowed
ERA
yes/no
 
 
arc_gl_sum
Summarized Journal
Summ Jrnl
yes/no
 
 
arc_jrnl
Next Journal
Journl
999999
 
 
arc_memo
Next Memo
Memo
99999999
 
 
arc_memo_pre
Memo Prefix
Pre
x(3)
 
 
arc_nxt_drft
Next Draft
Draft
x(8)
 
 
arc_nxt_pmt
Next Payment
Payment
x(8)
 
 
arc_sum_lvl
AR Summarization Level
AR!Summ!Lvl
9
 
 
arc_use_drft
Use Draft Management
Use!Drft
yes/no
 
 
arc_user1
Ufld1
 
x(8)
 
 
arc_user2
Ufld2
 
x(8)
 
 
oid_arc_ctrl
 
 
>>>>>>>>>>>>>>>>>>>>>>>>>>>9.9<<<<<<<<<
10
 
 
 
Index-Name
Uni
Field-Name
Asc
Abbr
arc_index1
yes
arc_domain
yes
no
 
oid_arc_ctrl
yes
oid_arc_ctrl
yes
no
arfld_det
Attribute Resource Function Link Detail
 
 
Field Name
Label
Col-Label
Format
Dec
 
arfld__qadc01
 
 
x(24)
 
 
arfld__qadc02
 
 
x(24)
 
 
arfld_fnc
Function Name
Function
x(20)
 
 
arfld_mod_date
Modified Date
Mod Date
99/99/99
 
 
arfld_mod_userid
User ID
 
x(8)
 
 
arfld_res_uri
Resource URI
URI
x(256)
 
 
arfld_sub_res
Sub-Resource
 
x(24)
 
 
arfld_user1
User Field Character 1
 
x(24)
 
 
arfld_user2
User Field Character 2
 
x(24)
 
 
oid_arfld_det
 
 
>>>>>>>>>>>>>>>>>>>>>>>>>>>9.9<<<<<<<<<
10
 
 
 
Index-Name
Uni
Field-Name
Asc
Abbr
arfld_res_sub
yes
arfld_res_uri
yes
no
 
 
 
arfld_sub_res
yes
no
 
arfld_sub_res
no
arfld_sub_res
yes
no
 
oid_arfld_det
yes
oid_arfld_det
yes
no
asbcm_mstr
Advanced Self-Billing Customer Data Master
 
 
Field Name
Label
Col-Label
Format
Dec
 
asbcm__qadc01
 
 
x(24)
 
 
asbcm__qadc02
 
 
x(24)
 
 
asbcm__qadc03
 
 
x(8)
 
 
asbcm__qadd01
 
 
->>>>,>>>,>>9.9
10
 
asbcm__qadi01
 
 
->,>>>,>>9
 
 
asbcm__qadl01
 
 
yes/no
 
 
asbcm__qadt01
 
 
99/99/99
 
 
asbcm_ar_accr_acct
Self-Billing AR Accrual Account
 
x(8)
 
 
asbcm_ar_accr_cc
Self-Billing AR Accrual CC
 
x(4)
 
 
asbcm_ar_accr_project
Self-Billing AR Accrual Project
 
x(8)
 
 
asbcm_ar_accr_sub
Self-Billing AR Accrual Sub-Acct
 
x(8)
 
 
asbcm_blocked_ln
Blocked line method
 
yes/no
 
 
asbcm_cust
Customer
 
x(8)
 
 
asbcm_cust_mtch_addr
Customer Matching Address
 
x(8)
 
 
asbcm_cust_mtch_mthd
Customer Matching Method
 
x(2)
 
 
asbcm_domain
Domain
Domain
x(8)
 
 
asbcm_excl_list
Shipper Exclusion List
 
x(60)
 
 
asbcm_gl_acct
Self-Billing GL Account
 
x(8)
 
 
asbcm_gl_cc
Self-Billing GL CC
 
x(4)
 
 
asbcm_gl_project
Self-Billing GL Project
 
x(8)
 
 
asbcm_gl_sub
Self-Billing GL Sub-Acct
 
x(8)
 
 
asbcm_mod_date
Modified Date
Mod Date
99/99/99
 
 
asbcm_mod_userid
User ID
 
x(8)
 
 
asbcm_prefix_list
Shipper Prefix List
 
x(30)
 
 
asbcm_ship_date
Ship Date threshold
 
99/99/99
 
 
asbcm_sls_accr_acct
Self-Billing Sales Accrual Acct
 
x(8)
 
 
asbcm_sls_accr_cc
Self-Billing Sales Accrual CC
 
x(4)
 
 
asbcm_sls_accr_project
Self-Billing Sales Accrual Project
 
x(8)
 
 
asbcm_sls_accr_sub
Self-Billing Sales Accrual Sub-Acct
 
x(8)
 
 
asbcm_tol_amt
Tolerance Amount
 
>>>>,>>>,>>9.99<<<
10
 
asbcm_tol_rate
Tolerance Rate
 
>>,>>9.99999<<<<<
10
 
asbcm_user1
User Field Character 1
 
x(24)
 
 
asbcm_user2
User Field Character 2
 
x(24)
 
 
oid_asbcm_mstr
 
 
>>>>>>>>>>>>>>>>>>>>>>>>>>>9.9<<<<<<<<<
10
 
 
 
Index-Name
Uni
Field-Name
Asc
Abbr
asbcm_cust
yes
asbcm_domain
yes
no
 
 
 
asbcm_cust
yes
no
 
oid_asbcm_mstr
yes
oid_asbcm_mstr
yes
no
asbc_ctrl
Self-Billing Control
 
 
Field Name
Label
Col-Label
Format
Dec
 
asbc__qadc01
 
 
x(24)
 
 
asbc__qadc02
 
 
x(24)
 
 
asbc__qadc03
 
 
x(8)
 
 
asbc__qadd01
 
 
->>>>,>>>,>>9.9
10
 
asbc__qadi01
 
 
->,>>>,>>9
 
 
asbc__qadl01
 
 
yes/no
 
 
asbc__qadt01
 
 
99/99/99
 
 
asbc_accr_daybook
Accrual Daybook
Accr DayBook
x(8)
 
 
asbc_accrual
Activate Self-Billing Accrual Mode
Self-Billing Accr Mod
yes/no
 
 
asbc_active
Active Advanced Self-Billing
Active
yes/no
 
 
asbc_domain
Domain
 
x(8)
 
 
asbc_excl
Enable Shipper Exclusion
Shipper Excl
yes/no
 
 
asbc_match_mthd
Default Customer Matching
Cust Match
x(2)
 
 
asbc_mod_date
Modified Date
Mod Date
99/99/99
 
 
asbc_mod_userid
User ID
 
x(8)
 
 
asbc_pd_ar_posting
Avoid AR Posting for PD Inv Lines
Avoid AR Posting
yes/no
 
 
asbc_rev_accr_daybook
Reversal Accrual Daybook
Rev Accr Daybook
x(8)
 
 
asbc_user1
User Field Character 1
 
x(24)
 
 
asbc_user2
User Field Character 2
 
x(24)
 
 
asbc_val_cust_part
Activate Customer Item Validation
 
yes/no
 
 
oid_asbc_ctrl
 
 
>>>>>>>>>>>>>>>>>>>>>>>>>>>9.9<<<<<<<<<
10
 
 
 
Index-Name
Uni
Field-Name
Asc
Abbr
asbc_domain
yes
asbc_domain
yes
no
 
oid_asbc_ctrl
yes
oid_asbc_ctrl
yes
no