SRAgreementHeader
| SRCompany | SRDivision | SRAgreementNo | SRAgreementDesc | 
|---|---|---|---|
| - | AAA | 14001001 | Variant 1 - Fixed rate, Wide selection | 
| - | AAA | 14001002 | Variant 2 - Fixed rate, Facility A01 Whs | 
| - | AAA | 14001003 | Variant 3 - Different fixed, Fac A01 Whs | 
| - | AAA | 14001004 | Variant 4 - USSup, Diff fixed, Faci A01 | 
| - | AAA | 14001005 | Variant 5 - Scaled Best Rate, Faci A01 | 
| - | AAA | 14001006 | Variant 6 - Base-Child | 
| - | AAA | 14001007 | Variant 7 - Scaled rate, Quantity unit | 
| SRAgrType | SRAgrGroup | SRPriority | SRStatus | 
|---|---|---|---|
| LINE | NULL | 5 | A | 
| LINE | NULL | 5 | A | 
| LINE | NULL | 5 | A | 
| LINE | NULL | 5 | A | 
| LINE | NULL | 5 | A | 
| LINE | NULL | 5 | A | 
| LINE | NULL | 5 | A | 
| SRValidFrom | SRValidTo | SRAgrDate | SRSupplierNo | 
|---|---|---|---|
| <Jan1 of current year> | <Dec31 of next year> | <current date> | Y90001 | 
| <Jan1 of current year> | <Dec31 of next year> | <current date> | Y90001 | 
| <Jan1 of current year> | <Dec31 of next year> | <current date> | Y90001 | 
| <Jan1 of current year> | <Dec31 of next year> | <current date> | NULL | 
| <Jan1 of current year> | <Dec31 of next year> | <current date> | NULL | 
| <Jan1 of current year> | <Dec31 of next year> | <current date> | Y90001 | 
| <Jan1 of current year> | <Dec31 of next year> | <current date> | Y90001 | 
| SRSupplierRef | SRSupplierGroup | SRSupplierTable | SRWarehouseCode | 
|---|---|---|---|
| Variant 1 | NULL | NULL | 001 | 
| Variant 2 | NULL | NULL | NULL | 
| Variant 3 | NULL | NULL | NULL | 
| Variant 4 | NULL | USA | NULL | 
| Variant 5 | NULL | USA | NULL | 
| Variant 6 | NULL | NULL | 001 | 
| Variant 7 | NULL | NULL | 001 | 
| SRWhseTable | SRWhseException | SRAgreementUnit | SRScaleUM | 
|---|---|---|---|
| NULL | NULL | G | NULL | 
| A01 | NULL | G | NULL | 
| A01 | NULL | G | NULL | 
| A01 | NULL | G | NULL | 
| A01 | NULL | G | NULL | 
| NULL | NULL | G | NULL | 
| NULL | NULL | Q | EA | 
| SRPayingUnit | SRGuaranteedRebateRate | SRCurrency | SRExchangeRateType | 
|---|---|---|---|
| G | NULL | USD | 1 | 
| G | NULL | USD | 1 | 
| G | NULL | USD | 1 | 
| G | NULL | USD | 1 | 
| G | NULL | USD | 1 | 
| G | NULL | USD | 1 | 
| G | NULL | USD | 1 | 
| SRIncludeReturns | SRPayee | SRPaymentMethod | SRPaymentTerms | 
|---|---|---|---|
| 0 | Y90001 | CH1 | N30 | 
| 0 | Y90001 | CH1 | N30 | 
| 0 | Y90001 | CH1 | N30 | 
| 0 | Y90001 | CH1 | N30 | 
| 0 | Y90001 | CH1 | N30 | 
| 0 | Y90001 | CH1 | N30 | 
| 0 | Y90001 | CH1 | N30 | 
| SRMaxRebateAmt | SRMinRebateAmt | SRRebateManager | SREmailAddrBuying | 
|---|---|---|---|
| 0 | 0 | NULL | NULL | 
| 0 | 0 | NULL | NULL | 
| 0 | 0 | NULL | NULL | 
| 0 | 0 | NULL | NULL | 
| 0 | 0 | NULL | NULL | 
| 0 | 0 | NULL | NULL | 
| 0 | 0 | NULL | NULL | 
| SRExpAlertIndBuying | SRExpDaysBuying | SRCompAlertIndBuying | SRCompletionRateBuying | 
|---|---|---|---|
| 0 | NULL | 0 | NULL | 
| 0 | NULL | 0 | NULL | 
| 0 | NULL | 0 | NULL | 
| 0 | NULL | 0 | NULL | 
| 0 | NULL | 0 | NULL | 
| 0 | NULL | 0 | NULL | 
| 0 | NULL | 0 | NULL | 
| SRSupplierContact | SREmailAddrSupplying | SRExpAlertIndSupplying | SRExpDaysSupplying | 
|---|---|---|---|
| NULL | NULL | 0 | NULL | 
| NULL | NULL | 0 | NULL | 
| NULL | NULL | 0 | NULL | 
| NULL | NULL | 0 | NULL | 
| NULL | NULL | 0 | NULL | 
| NULL | NULL | 0 | NULL | 
| NULL | NULL | 0 | NULL | 
| SRCompAlertIndSupplying | SRCompletionRateSupplying | SRRebateMethod | SRScale | 
|---|---|---|---|
| 0 | NULL | FR | NULL | 
| 0 | NULL | FR | NULL | 
| 0 | NULL | FR | NULL | 
| 0 | NULL | FR | NULL | 
| 0 | NULL | SR | ZBST1 | 
| 0 | NULL | SR | ZBST1 | 
| 0 | NULL | SR | ZBST1 | 
| SRRebateCalcPercent | SRRebateCalcAmt | SRPOCategory | SRPOCategoryTable | 
|---|---|---|---|
| 5 | NULL | NULL | NULL | 
| 5 | NULL | NULL | NULL | 
| 7 | NULL | NULL | NULL | 
| 8 | NULL | NULL | NULL | 
| NULL | NULL | NULL | NULL | 
| NULL | NULL | NULL | NULL | 
| NULL | NULL | NULL | NULL |