|
|
ERSAOCDTL FILE
ERS Add On Cost Detail
This file contains add on cost detail information that is captured at receipt
time for evaluated receipt settlement PO's.
REFERENCED BY
MA530 PO35.1
UPDATED BY
PO30.1 PO30.2 PO38.1 PO530
FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
ERS-COMPANY Numeric 4 PO30.1 PO30.2
Company The company number. PO38.1 PO530
ERS-REC-NUMBER Alpha 10 (Right Justified) PO30.1 PO30.2
Receiver Number The receiver number. Assigned when PO38.1 PO530
this receiving information was added.
ERS-LINE-NBR Numeric 6 PO30.1 PO30.2
Line Number This field contains the line number. PO38.1 PO530
ERS-AOC-CODE Alpha 2 PO30.1 PO30.2
Add On Cost Code This field contains the identifier for PO38.1 PO530
the add-on cost associated with this
line item.
ERS-TOTAL-AOC Signed 15.2 PO30.1 PO30.2
Total Add On Cost The total add-on cost amount can be an PO38.1 PO530
entered amount if entered at this level,
or a calculated amount if a unit add-on
cost or add-on cost percent is entered.
ERS-AOC-SOURCE Numeric 1
Aoc Source 0 = AOC From POAOCDTL File
1 = AOC From POAOCSPRD File
ERSAOCDTL FILE INDEX
NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
ERSSET1 COMPANY MA530 PO30.1
REC-NUMBER PO30.2 PO35.1
LINE-NBR PO38.1 PO530
AOC-CODE
ERSAOCDTL FILE RELATIONS
ONE TO ONE RELATIONS
RELATION RELATED
NAME FILE INTEGRITY RULES / FIELD MATCH
Poaocmast POAOCMAST Required
ERS-COMPANY -> PAM-COMPANY
ERS-AOC-CODE -> PAM-AOC-CODE
Poreceive PORECEIVE Not Required
ERS-COMPANY -> POR-COMPANY
ERS-REC-NUMBER -> POR-REC-NUMBER
Porecline PORECLINE Not Required
ERS-COMPANY -> PRL-COMPANY
"PO" -> PRL-DOC-TYPE
ERS-REC-NUMBER -> PRL-DOCUMENT
ERS-LINE-NBR -> PRL-LINE-NBR
|