POCOMMENTS FILE
Comments File
This file contains all Purchase Order comments associated with both actual
and standard Purchase Orders.
REFERENCED BY
DR100 IC141 IC142 IC83.1 MA40.1 MA40.2
MA41.1 MA41.2 MA41.3 MA41.5 MA43.1 MA43.2
MA43.3 PO120 PO121 PO123 PO130 PO132
PO220 PO221 PO223 PO225 PO230 PO231
PO30.1 PO64.1 RQ10.1 RQ10.3 RQ11.1 RQ35.1
RQ500
UPDATED BY
BL92.1 MA300 OE10.1 OE10.2 OE10.3 OE10.4
OE10.5 OE10.6 OE10.7 OE10.8 OE11.1 OE11.4
OE11.8 OE11.9 OE110 OE113 OE114 OE129
OE14.4 OE15.1 OE15.2 OE15.3 OE15.4 OE15.5
OE15.7 OE510 OE810 OE920 PO100 PO20.1
PO21.4 PO22.2 PO22.3 PO25.1 PO25.2 PO28.7
PO31.1 PO32.4 PO32.5 PO820 PO821 PO822
RQ20.1 RQ20.4 WH20.2 WH20.7
FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
POC-COMPANY Numeric 4 PO100 PO20.1
Company The company number represents a defined PO21.4 PO25.1
company and is selected on all action PO28.7 PO31.1
codes. PO32.4 PO32.5
PO820 PO821
For conversion: PO822 RQ20.1
Fatal error: If equal to spaces, or RQ20.4
zeroes, or not numeric, or either
Purchase Order company, Inventory
Control company, or Accounts Payable
company is not found, then the comment
record is not loaded.
POC-ORDER-NAME Alpha 10 PO100 PO20.1
Standard Order Name The user-defined standard order name. PO21.4 PO22.2
PO22.3 PO25.1
PO28.7 PO31.1
PO32.4 PO32.5
PO820 PO821
PO822 RQ20.1
RQ20.4
POC-PO-NUMBER Alpha 7 (Right Justified) PO100 PO20.1
PO Number This field contains the number PO21.4 PO22.2
representing the purchase order. PO22.3 PO25.1
PO28.7 PO31.1
For conversion: PO32.4 PO32.5
Fatal error: If equal to spaces, or PO820 PO821
purchase order company flag says it must PO822 RQ20.1
be numeric and it is not, or the RQ20.4
purchase order cannot be found, then
the comment record is not loaded.
POC-PO-RELEASE Numeric 6 PO100 PO20.1
PO Release Number Used to identify a purchase order PO21.4 PO22.2
release (created from a Blanket or PO22.3 PO25.1
Standing order). PO28.7 PO31.1
PO32.4 PO32.5
PO820 PO821
PO822 RQ20.1
RQ20.4
POC-RETURN-NUMBER Numeric 10 PO31.1 PO32.4
Return Number This is the number assigned to the PO32.5 RQ20.1
return for purposes of referencing the RQ20.4
return internally and with the customer
or vendor.
POC-LINE-NBR Numeric 6 PO100 PO20.1
Line Number This field contains the line number. PO21.4 PO22.2
PO22.3 PO25.1
For conversion: PO28.7 PO31.1
0 indicates header comments PO32.4 PO32.5
999999 indicates trailer comments PO820 PO821
PO822 RQ20.1
Fatal error: If not numeric, then the RQ20.4
comment record is not loaded.
POC-SEQ Numeric 3 PO100 PO20.1
Sequence Number This field contains the record sequence PO21.4 PO22.3
number. The system assigns these numbers PO25.1 PO28.7
sequentially beginning with 1. PO31.1 PO32.4
PO32.5 PO64.1
For Conversion: PO820 PO821
Sequence number must start with 2, when PO822 RQ20.1
loading comment records. RQ20.4
POC-COMMENT Alpha 40 (Lower Case) PO100 PO20.1
Comment Line This field contains the comment PO21.4 PO25.1
narrative. PO28.7 PO31.1
PO32.4 PO32.5
PO820 PO821
PO822 RQ20.1
RQ20.4
POC-PRINT-CODE Alpha 1 PO100 PO20.1
Print Code This field contains the print code, PO21.4 PO25.1
which defines where comments are PO28.7 PO31.1
displayed or printed. PO32.4 PO32.5
B = Display and Print PO820 PO821
D = Display Only PO822 RQ20.1
P = Purchase Order RQ20.4
R = Receiver
POCOMMENTS FILE INDEX
NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
POCSET1 COMPANY BL92.1 DR100
ORDER-NAME IC141 IC142
RETURN-NUMBER IC83.1 MA300
PO-NUMBER MA40.1 MA40.2
PO-RELEASE MA41.1 MA41.2
LINE-NBR MA41.3 MA41.5
SEQ MA43.1 MA43.2
MA43.3 OE10.1
OE10.2 OE10.3
OE10.4 OE10.5
OE10.6 OE10.7
OE10.8 OE11.1
OE11.4 OE11.8
OE11.9 OE110
OE113 OE114
...
POCSET2 COMPANY Subset MA300 PO31.1
RETURN-NUMBER Where RETURN-NUMBER != Zeroes PO32.4 PO32.5
LINE-NBR
SEQ
POCOMMENTS FILE RELATIONS
ONE TO ONE RELATIONS
RELATION RELATED
NAME FILE INTEGRITY RULES / FIELD MATCH
Apcompany APCOMPANY Required
POC-COMPANY -> CPY-COMPANY
Iclocation ICLOCATION Required
POC-COMPANY -> ICL-COMPANY
PCR-LOCATION -> ICL-LOCATION
Poline POLINE Required
When POC-ORDER-NAME = Spaces
And (POC-LINE-NBR != Zeroes
Or POC-LINE-NBR != 999999 )
POC-COMPANY -> PLI-COMPANY
POC-PO-NUMBER -> PLI-PO-NUMBER
POC-PO-RELEASE -> PLI-PO-RELEASE
POC-LINE-NBR -> PLI-LINE-NBR
Poreturnhd PORETURNHD Not Required
Valid When POC-RETURN-NUMBER != Zeroes
POC-COMPANY -> PTH-COMPANY
POC-RETURN-NUMBER -> PTH-RETURN-NUMBER
Poreturnln PORETURNLN Not Required
Valid When POC-RETURN-NUMBER != Zeroes
POC-COMPANY -> PTL-COMPANY
POC-RETURN-NUMBER -> PTL-RETURN-NUMBER
POC-LINE-NBR -> PTL-RET-LINE-NBR
Purchorder PURCHORDER Required
When POC-ORDER-NAME = Spaces
POC-COMPANY -> PCR-COMPANY
POC-PO-NUMBER -> PCR-PO-NUMBER
POC-PO-RELEASE -> PCR-PO-RELEASE
Stpoline STPOLINE Required
When POC-PO-NUMBER = Spaces
And (POC-LINE-NBR != Zeroes
Or POC-LINE-NBR != 999999 )
POC-COMPANY -> SPL-COMPANY
POC-ORDER-NAME -> SPL-ORDER-NAME
POC-LINE-NBR -> SPL-LINE-NBR
Stpurchord STPURCHORD Required
When POC-PO-NUMBER = Spaces
And POC-PO-RELEASE = Zeroes
Or (POC-LINE-NBR = Zeroes
Or POC-LINE-NBR = 9999 )
POC-COMPANY -> SPO-COMPANY
POC-ORDER-NAME -> SPO-ORDER-NAME
Vendor APVENMAST Required
When POC-PO-NUMBER != Spaces
CPY-VENDOR-GROUP -> VEN-VENDOR-GROUP
PCR-VENDOR -> VEN-VENDOR
|